In the previous post, we used Dynamics 365 Dashboard and Power BI Tile to show Power BI Dashboard and report inside Dynamics 365.
Now as a next step, we want to make sure that the users are looking at the latest data possible inside the Dashboard\Reports.
In case of Online Services like Dynamics 365 (Online), we have the option to manually Refresh the data.
To see it in action, let us create a lead record in Dynamics 365.
This is how our Dashboard looks like for now à
Now back in Power BI Service right, click on ellipsis for the Dataset and select Refresh Now.
We can see the newly created lead in our Power BI Report inside Power BI Service and Dynamics 365 CE.
The other option we have is to Schedule the refresh.
Navigate to the Dataset and select Schedule Refresh
We can select the Refresh Frequency as Daily or Weekly.
And we can set it to refresh up to 8 times per day as shown below.
With Power BI Pro License, we can complete the scheduled refresh 8 times a day whereas the Power BI Premium allows the refresh up to 48 times per day.
https://powerbi.microsoft.com/en-us/power-bi-premium/
Some helpful links
https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh
https://www.powerobjects.com/2018/01/11/power-bi-data-refresh-performance/
https://crmtipoftheday.com/category/power-bi/
Hope it helps..
4 thoughts on “Power BI with Dynamics 365 CE – Refreshing the Dataset”