Can 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