Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi, is there a way to configure scheduled refresh for report that pulls data from Business Central? Also we'd like to use entra app instead of an account as MFA is required for the second option which affects our refreshes in power bi service sometimes.
Solved! Go to Solution.
Hi @Taras_WSI ,
Power BI Report Server does not support scheduled refreshes for Dynamics 365 Business Central as a data source. If you are using Power BI Report Server, you would not be able to configure a scheduled refresh for this data source.
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Taras_WSI ,
Power BI Report Server does not support scheduled refreshes for Dynamics 365 Business Central as a data source. If you are using Power BI Report Server, you would not be able to configure a scheduled refresh for this data source.
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Experts,
I have a Power BI Report that has the combination of data coming from Business Central and CRM. In this report I am joining multiple tables with other in the Power Query part. When I am refreshing the dataset on the Power BI Desktop it is getting refreshed without any error. But, when I refresh the same dataset on Power BI Service, it is showing this error.
I have tried increasing the command timeout as well, but seems that is not the issue.
Please guide further.
Thank You!
If you are using merge and expand functions in Power Query then that is the most likely cause of the issue. Rather than using merge/expand, try to first load the tables, create a 1:many relationship and then use the RELATED() DAX function to add the columns you need from the dimension table (1 side of 1:many).
No, refresh for D365 (automatic and also manual) is not supported na on-premise PBI RS. Only option is (except move to Power BI cloud), is refresh in Power BI Desktop, and save back to RS portal
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
6 | |
4 | |
3 | |
3 | |
2 |