Power Platform self-service analytics Data Export to Data Lake [Preview] | Power Platform Admin Center

January 31, 2023 priyeshwagh777 Microsoft Azure, Power Platform, Power Platform Admin Center adls gen 2, data export to data lake, Power Platform Admin Center, power platform data export, power platform data export to data lake, self service analytics power platform

Now, you can also export the Analytics Data to Azure Data Lake in order to further extend the derive rich data analytics!
At the time of writing this post, this feature is in Preview (As you’ll also see from the screenshots below)

This is a great feature where you can extract this Data into Data Lake and then further enrich and derive rich Power BI reporting based on your use-case.

In case you are new to understanding Azure Data Lake and pricing, you can review this – https://azure.microsoft.com/en-gb/solutions/data-lake/?WT.mc_id=DX-MVP-5003911

Data Export (Preview)

In Power Platform Admin Center (https://admin.powerplatform.microsoft.com/), here’s how you can setup Data Export –

Navigate to Data Export in Power Platform Admin Center given that you have appropriate rights –
Then, you’ll get to choose amongst the Power Apps or Power Automate data to be exported to Data Lake.
In this example, I’ll choose Power Automate. As I select Power Automate, you’ll see that Tenant-Level Analytics are required and hence, already considered as Yes. If not, you’ll need to Enable Tenant-Level Analytics while doing this step – Here’s another post on how to Enable and Use Tenant Level Analytics –
Now, In the next section you’ll need to choose the Subscription.
Further, select the Resource Group and eventually, the Storage Account as well.

And Storage Account is selected as well.
Once everything looks good, you can click on Create.
In a few moments, this will appear in Data Lake section of the Data Export. It will take up to 24 hours for the data to first start showing in Data Lake.
Once this is completed after about 24 hours, you’ll see the status of the Data Lake data package changed to connected.

Data Export to Data Lake

Let’s look at the Azure Storage Explorer to connect to our Data Lake and see the Power Platform data – In case you are looking to install Azure Storage Explorer, here’s a post – Microsoft Azure Storage Explorer | Getting Started

Once authenticated to the correct environment in Azure Storage Explorer, here’s what you would see in the ADLS Gen 2 (In case you want to create ADLS Gen 2 storage account, you can review this post – Create ADLS Gen 2 Storage Account for Azure Data Lake)
You’ll see powerplatform folder show up.
If you open this folder, since we had chosen Power Automate, it’s folder will be created.
And let’s go in Flows folder to see the data. You’ll find json files of the same. You can double click to open it and it’ll open in whatever editor you have installed.
In this case, I had VS Code, so here’s what the Flow data looks like –
Likewise, you can dig deeper in this data and use this further for your reporting!

Here’s Microsoft Learn Document on the same – https://learn.microsoft.com/en-us/power-platform/admin/self-service-analytics?WT.mc_id=DX-MVP-5003911

Here’s Microsoft Learn Docs for Tenant-Level Analytics – https://learn.microsoft.com/en-gb/power-platform/admin/tenant-level-analytics#how-do-i-enable-tenant-level-analytics?WT.mc_id=DX-MVP-5003911

Hope this helps!

Here are some Power Automate posts you want to check out –

Thank you!

Tenant-Level Analytics in Power Platform Admin Center | For Power Apps and Power Automate

January 30, 2023February 5, 2023 priyeshwagh777 Power Platform Admin Center power platform admin center analytics, tenant level analysis for power platform, tenant level analytics, tenant level analytics power platform admin center, tenant level analytics reporting

As your organization and tenant usage grows, it’s difficult to keep track of Adoption. To tackle this, Tenant-Level Analytics have been introduced in Power Platform Admin Center (https://admin.powerplatform.microsoft.com/).

Let’s see how we can turn this on for your tenant!

Enable Tenant-Level Analytics

Given that you have appropriate permissions in Power Platform Admin Center, here’s how you can enable Tenant-Level Analytics –

In Power Platform Admin Center, look for Settings area – under this, you’ll see an option called as Analytics –
Once you select Analytics, you’ll see on the right-hand side, a simple switch to turn it On. it could be Off by default.
Once you Turn if On and Save, you’ll also see a confirmation message.

And it’ll show this message once applied.
Now, do a complete Broswer refresh.

Reading Tenant-Level Analytics

Here’s how you can review tenant-level analytics once enabled for your Tenant via the Power Platform Admin Center –

When Tenant-Level Analytics are disabled, you’ll not find anything on the top right corner of the Analytics under Power Automate or Power Apps

Tenant-Level Analytics: OFF (for both, Power Automate and Power Apps)

Tenant-Level Analytics: ON
You can drop down on the menu and find Tenant-Level Analytics.
Once you choose Tenant level analysis, you’ll see the below report show up – this is the same for Power Automate as well as Power Apps.
Please note that it takes up to 24 to 48 hours for the metrics to start showing from the previous day.
And after approx. 48 hours later, I see this data now showing up.

Hope this helps!

Here are some Power Automate posts you want to check out –

Thank you!

Create ADLS Gen 2 Storage Account for Azure Data Lake

January 29, 2023January 29, 2023 priyeshwagh777 Microsoft Azure adls gen 2, azure data lake, azure data lake gen 2 storage, azure storage account, data lake storage

Here’s how you can create an ADLS Gen 2 Storage for Azure Data Lake!

Resource Group and Storage Account

In case you don’t have a Resource Group already, create one and have all the new Resources including this Storage Account also in this new one.

I have a blank Resource Group called Jan 2023. It is blank and hence, I’ll start by creating Azure Storage in the same.
When in the Resource Group, look for + Create button and it’ll take you to the Marketplace to create Storage Account.
Once in Marketplace, search for “Storage Account” and you’ll see one by Microsoft as below. Click on Create.
Once you click on Create (it may expand and let you click on Storage Account action – redundant, but it is what it is)
Then, enter all the details, make sure the correct Resource Group is selected and give a name (no special characters and it has to be in small caps) to the Storage Account.
Once I click on Next: Advanced, look for Data Lake Gen 2 area in Advanced tab (which would be disabled by default).
Click on Enable Hierarchical namespace to make it Gen 2
Make sure you have checked Enable hierarchical namespace option.
Finally, review all the options you may have made. I’ve not changed anything else to keep it within the context of this blog.
Then, once the button is enabled.
On the final page, it might take a few moments for the Create button to appear. Once everything looks good, click on Create.
It’ll start deployment as any other resource in Azure and you’ll know once it’s completed.
And this will complete in a few moments.
Once this is completed, you can also check in Azure Storage Explorer
Below is how it’ll appear in the Azure Storage Explorer.
In case you are looking to setup and use Azure Storage Explorer, you can check this post – Microsoft Azure Storage Explorer | Getting Started

And your Gen 2 Storage for Data Lake is created.

Hope this helps!

Here are some Power Automate posts you want to check out –

Thank you!

Microsoft Azure Storage Explorer | Getting Started

January 29, 2023 priyeshwagh777 Microsoft Azure azure storage explorer, install microsoft storage explorer, microsoft azure storage explorer, storage explorer

If you are wondering how to get and setup the Microsoft Azure Storage Explorer – Here’s this post!

Azure Storage Explorer

Here’s how you can download and setup Microsoft Azure Storage Explorer.

Search For Azure Storage Explorer and you’ll see something as below –
Once you open the azure.microsoft.com link, you’ll see the below –
Drop down to select Windows. And the Setup will will be prompted to save on your browser (or directly download based on your browser settings)
And it’ll appear that it has been downloaded to your machine.
Now, click on the Setup and let it start. Accept the Terms if everything looks OK to you, then click on Install
It’ll then ask you where to setup and what it should call on the system. Standard stuff.
Then, installation will begin.
Then, open it up when finished.
Now, this will come up. You are now ready to Sign-In!

Sign In with Azure in Microsoft Storage Explorer

Now, picking up from the step above, here’s how you sign in –

Click on the Sign In with Azure if that’s your case unless you are trying other options in this wizard.
If your Azure is usual one to login, can you simply click on Azure and click Next.
Then, you’ll be asked to authenticate. Enter your credentials and authenticate like you would for any Microsoft Account.
Once successful, you’ll see this and you can close the window.
Now, if you open the App, it’ll detect your Azure Subscription if you have one.
If it looks correct, you can simply click on Open Explorer.
Once opened, you can expand on the Subscription and see all your Storage Accounts.

Hope this helps!

Here are some Power Automate posts you want to check out –

Thank you!

Tracked Properties in Power Automate Flow Step

January 23, 2023 priyeshwagh777 Power Automate power automate flow, tracked properties, tracked properties in flow, tracked properties in flow step settings, tracked properties in power automate

If you are new to Power Automate and are wondering how Tracked Properties are and how they work?

Tracked Properties are data properties which are hidden away from the Input/Output sections of the Flow and which you can explicitly retrieve in a Flow Run.

Here’s a post to explain the same!

Tracked Properties

Below are what Tracked Properties are –

If you look at the Settings section of different Actions, you’ll see Tracked Properties.
And you’ll see Tracked Properties at the bottom once all Action specific Settings are listed.
Here, you can create and store your own properties and it’s value. It’s value could also be results of preceding steps or from expressions.
See example below –
Once you create these Properties, here’s how you can retrieve the same.

Retrieving Tracked Properties

Here’s how you can retrieve Tracked Properties –

You need to address using actions() method in Power Automate to read Tracked Properties of a certain step.
Hence, the syntax is “action('<stepname>')?['TrackedProperties']“
You can store it in an Object variable and see the result as below
Or, if you want to retrieve only a specific property, you can mention the same in the expressions itself.
And it’ll show up like this (In anything stores Integer / String)

Hope this helps!

Here are some Power Automate posts you want to check out –

Thank you!

Smart Buttons in Ribbon Workbench | XrmToolBox

January 17, 2023 priyeshwagh777 Ribbon Workbench ribbon workbench xrmtoolbox, smart button, smart buttons, smart buttons ribbon workbench, XrmToolBox

You must’ve definitely used Scott Durow’s Ribbon Workbench in XrmToolBox which is one of the most popular tools for in the XrmToolBox. Here’s what Smart Buttons can do to further extend capabilities of the Ribbon!

Let’s see how you can install Smart Buttons if you already have not installed the solution in your environment and also I’ll summarize how each of these will work! Hope this post captures the bare-minimum well.

Installing Smart Buttons

Here’s how you can install the Smart Buttons solution to make it appear in your Ribbon Workbench!
Link: Install Smart Buttons for Ribbon Workbench | XrmToolBox

Smart Button Posts

Run Report – https://d365demystified.com/2023/01/17/run-report-using-smart-button-in-ribbon-workbench-xrmtoolbox/
Run Workflow – https://d365demystified.com/2023/01/17/run-workflow-smart-button-in-ribbon-workbench-xrmtoolbox/
Run Webhook – https://d365demystified.com/2023/01/17/run-webhook-smart-button-in-ribbon-workbench-xrmtoolbox/
Quick JS – https://d365demystified.com/2023/01/17/run-js-snippet-using-smart-button-in-ribbon-workbench-xrmtoolbox/
Open Dialog – https://d365demystified.com/2023/01/17/open-dialog-using-smart-button-in-ribbon-workbench-xrmtoolbox/

Hope this helps!

Here are some Power Automate posts you want to check out –

Thank you!

Open Dialog using Smart Button in Ribbon Workbench | XrmToolBox

January 17, 2023 priyeshwagh777 Ribbon Workbench open dialog in dynamics 365 crm, open dialog ribbon workbench, Ribbon Workbench

Here’s how you can use Dialog from Smart Buttons in Ribbon Workbench. In case you haven’t yet installed Smart Buttons in your Ribbon Workbench for your organization – Here’s a post for that – Install Smart Buttons for Ribbon Workbench | XrmToolBox

Now that it’s given you might have installed Smart Buttons already, let’s review how you can use the Run Report button for your Organization

Scenario

Run Dialog button

Here’s how you can open a Canvas App as a Dialog in a Model-Driven App –

In Ribbon Workbench, you can see the Open Dialog option in the Smart Buttons menu in Ribbon Workbench.
Upon Dragging it to the ribbon (I’m using the Form ribbon in this example), you’ll be asked the below in a Dialog box.
Title should have the title which the button should show on the ribbon.
Dialog URL or Custom Page Unique Name should have the URL or the name of the Custom Page you have in your Model-driven App (I’ll share links below on how to get both from the official source itself)
Width and Height as suggests should be specified in pixel dimensions.
Dialog Title should show how the Dialog Box should look like.
Here’s how the Custom Page’s name is (make sure the Custom Page is also added to the Model-Driven App your ribbon is in)
Below are the links for both – Canvas App and Custom Page which can be added in the Dialog.

Links:
Custom Page to be added to the Open Dialog button – https://www.develop1.net/public/post/2021/08/08/custom-page-dialog-smart-button
Canvas App to be added to the Open Dialog button – https://www.develop1.net/public/post/2020/09/30/new-smart-button-custom-dialogs-in-model-driven-apps-using-canvas-apps
Once this is done, it’ll appear on the ribbon and once you confirm, you can commit the changes by Publishing the customization.
Once this is done, publish and let’s see how the customization will look.

Working

Now that the customization are published, you can see as below –

Here’s the button on the Form ribbon I added to.
When you click it, the dialog box will appear as below –

Hope this helps!

Here are some Power Automate posts you want to check out –

Thank you!

Run JS snippet using Smart Button in Ribbon Workbench | XrmToolBox

January 17, 2023 priyeshwagh777 Ribbon Workbench quick js ribbon workbench, quick js smart button, Ribbon Workbench, smart button ribbon workbuench

Here’s how you can call a piece of JavaScript code snippet from Smart Buttons in Ribbon Workbench. In case you haven’t yet installed Smart Buttons in your Ribbon Workbench for your organization – Here’s a post for that – Install Smart Buttons for Ribbon Workbench | XrmToolBox

Now that it’s given you might have installed Smart Buttons already, let’s review how you can use the Run Report button for your Organization

Quick JS

Here’s how you can run a small snippet of code when upon clicking the Ribbon button –

Here’s the Smart Button you can use to run a snippet of JS code.
When you drag the same on the ribbon (Form Ribbon in this case), you’ll be asked the below parameters – the Name of the button and the JS code you want to run.
Once you’ve entered this, you can see the button show up. Finally, publish the changes and check on the actual record (or Grid based on where you have used this)

Working

Here’s how the button will act upon using Quick JS Smart Button –

You can see that the button is now shown on the Form.
I opened to Console in Dev Tools to show what the JS snippet will do (since in this example, it’s supposed to Log a message in the console).

Hope this helps!

Here are some Power Automate posts you want to check out –

Thank you!

Run Webhook Smart Button in Ribbon Workbench | XrmToolBox

January 17, 2023 priyeshwagh777 Ribbon Workbench Ribbon Workbench, run webhook ribbon workbench, run webhook smart button

You can even Run Webhooks from the ribbon button in Dynamics 365 CRM using the Ribbon Workbench’s Smart Buttons.

In case you haven’t yet installed Smart Buttons in your Ribbon Workbench for your organization – Here’s a post for that – Install Smart Buttons for Ribbon Workbench | XrmToolBox

Now that it’s given you might have installed Smart Buttons already, let’s review how you can use the Run Report button for your Organization

Scenario

For this example – have an HTTP Flow which I want to call using the Smart Button in Ribbon Workbench

For that matter, you can call a Webhook using Run Webhook Smart Button in Ribbon Workbench, let’s see how.

Run Webhooks button

Before we begin, add the entity-only in a Solution and then load it up into Ribbon Workbench –

You can see the Run Webhook button in the Ribbon Workbench menu as below.
When you drag it on the ribbon on the (on the Account Form in this example), you’ll see the below parameters pop-up.
Title should have the title of the Button to be called on the ribbon.
Web Hook URL should have the complete URL for the Webhook – An HTTP Flow here.
Start Confirmation Text should have the text which should be displayed on the confirmation dialog when you trigger this button for Webhook.
Success Callback JavaScript should have the JS snippet of what should happen if the Webhook call succeeds.
Error Callback JavaScript should have the JS snippet of what should happen if the Webhook call fails.
Once you click OK, you should see the button show up on the ribbon where you have added it.
You can double-click the button here and see if you need to add any additional properties.
Once you are done, you can publish your changes.

Working

Now, that the changes have been published, let’s look at the Ribbon button –

When you refresh the form, you’ll see that the button has now appeared.
And when you click the same, you’ll be asked the text you entered in the pop-up dialog.
Once you click OK, the Webhook will be triggered and the Flow will be hit (in this example)
In this scenario, it’ll only pass the id of the record.

Hope this helps!

Here are some Power Automate posts you want to check out –

Thank you!

Run Workflow Smart Button in Ribbon Workbench | XrmToolBox

January 17, 2023 priyeshwagh777 Ribbon Workbench Ribbon Workbench, run workflow smart button, smart buttons for ribbon workbench

Here’s how you can use the Run Report button from Smart Buttons in Ribbon Workbench. In case you haven’t yet installed Smart Buttons in your Ribbon Workbench for your organization – Here’s a post for that – Install Smart Buttons for Ribbon Workbench | XrmToolBox

Now that it’s given you might have installed Smart Buttons already, let’s review how you can use the Run Report button for your Organization.

Scenario

I have a Workflow which updates the Account’s Account Grade field to the value Verified

And the field to be updated is as below –

Run Workflow button

Before we begin, add the entity-only in a Solution and then load it up into Ribbon Workbench –

You’ll see Smart Buttons show up in your Ribbon Workbench.
When you drag the button over to the Grid (Form in this case), you’ll be given this popup window to fill in the details of what the Run Workflow button should do –
Title should be the title of the Window.
Workflow Name should be the text Display Name of the Workflow itself.
Start Workflow Confirmation Text should have the text that should be displayed on the confirmation dialog when clicked on the button.
Success Callback JavaScript should have a JS snippet of what it should do upon success.
Error Callback JavaScript should have a JS snipped of what it should do upon error in Workflow execution.
Once you click OK, this is how it will appear.
And that’s it, publish your changes and reload the Page to see the Smart Button to Run the Workflow in action!

Working

Let’s see below on how this Workflow button will work –

On the Account form, I can now see this button being displayed and it has it’s Run Workflow icon built in.
When you click the button, you’ll be seeing this message.
And when it is running, you’ll see this notification on the form.
And when this is done, it’ll change the value (or whatever your workflow is supposed to do).

Hope this helps!

Here are some Power Automate posts you want to check out –

Thank you!

D365 Demystified

A closer look at Microsoft Dynamics 365.

Author: priyeshwagh777

Power Platform self-service analytics Data Export to Data Lake [Preview] | Power Platform Admin Center

Data Export (Preview)

Data Export to Data Lake

Tenant-Level Analytics in Power Platform Admin Center | For Power Apps and Power Automate

Enable Tenant-Level Analytics

Reading Tenant-Level Analytics

Create ADLS Gen 2 Storage Account for Azure Data Lake

Resource Group and Storage Account

Microsoft Azure Storage Explorer | Getting Started

Azure Storage Explorer

Sign In with Azure in Microsoft Storage Explorer

Tracked Properties in Power Automate Flow Step

Tracked Properties

Retrieving Tracked Properties

Smart Buttons in Ribbon Workbench | XrmToolBox

Installing Smart Buttons

Smart Button Posts

Open Dialog using Smart Button in Ribbon Workbench | XrmToolBox

Scenario

Run Dialog button

Working

Run JS snippet using Smart Button in Ribbon Workbench | XrmToolBox

Quick JS

Working

Run Webhook Smart Button in Ribbon Workbench | XrmToolBox

Scenario

Run Webhooks button

Working

Run Workflow Smart Button in Ribbon Workbench | XrmToolBox

Scenario

Run Workflow button

Working

Data Export (Preview)

Data Export to Data Lake

Share this:

Like this:

Enable Tenant-Level Analytics

Reading Tenant-Level Analytics

Share this:

Like this:

Resource Group and Storage Account

Share this:

Like this:

Azure Storage Explorer

Sign In with Azure in Microsoft Storage Explorer

Share this:

Like this:

Tracked Properties

Retrieving Tracked Properties

Share this:

Like this:

Installing Smart Buttons

Smart Button Posts

Share this:

Like this:

Scenario

Run Dialog button

Working

Share this:

Like this:

Quick JS

Working

Share this:

Like this:

Scenario

Run Webhooks button

Working

Share this:

Like this:

Scenario

Run Workflow button

Working

Share this:

Like this: