Forum Discussion
Helper IIICan power bi refresh data automatically when new data comes to dynamic 365 database?
Hi rickylee,
As I understand, you have a power BI report whcih you then publish to the Power BI Service and then from there to dyamic 365 dashboard - correct?
If so, you can achieve referehsing with scheduled refresh:
However, the scheduled refresh is fixed so it only happens at the time you've selected - and it is limited to 8 refreshes per day for free and pro users and 48 refrehses a day for premium users.
If you want to "force" a refresh every time data is changed, make a Flow with Microsoft Flow. This solution requires you to make a PowerBI custom connecter in Microsoft Flow. and I got it done with easy-to-follow instructions from this blog. I needed a similar refreshing feature for one of my reports and the only solution I found was making a Flow with Microsoft Flow and creating a custom Power BI connector to Flow. Please note, that the 8 or 48 refreshes a day limit still exists even if you use Flow.
Br,
T
Hi rickylee,
As I understand, you have a power BI report whcih you then publish to the Power BI Service and then from there to dyamic 365 dashboard - correct?
If so, you can achieve referehsing with scheduled refresh:
However, the scheduled refresh is fixed so it only happens at the time you've selected - and it is limited to 8 refreshes per day for free and pro users and 48 refrehses a day for premium users.
If you want to "force" a refresh every time data is changed, make a Flow with Microsoft Flow. This solution requires you to make a PowerBI custom connecter in Microsoft Flow. and I got it done with easy-to-follow instructions from this blog. I needed a similar refreshing feature for one of my reports and the only solution I found was making a Flow with Microsoft Flow and creating a custom Power BI connector to Flow. Please note, that the 8 or 48 refreshes a day limit still exists even if you use Flow.
Br,
T
Hey Anonymous,
That was a really cool blog post; thanks for the link. Are you saying that if you set this up, there is still the 8 refreshes a day limit? Meaning that the Microsoft Flow will fail after its 8th execution?
Thanks,
Parker
Anonymous,
To my knowledge, yes. I can't remember which one fails Flow or Power Bi but you'll get an error. IT depends on your Power Bi workspace/license: Pro gives 8 times and Premium 48 - this might have changed, I'm not sure.
However if you connect with direct query instead of import then the refresh is automatic and changes in the data automatically appear in your reports.
Br,
T
Thanks Anonymous. I appreciate the info