topic Re: D365 Business Central scheduled refresh on Power BI Report Server in Report Server

D365 Business Central scheduled refresh on Power BI Report Server

Taras_WSI — Wed, 07 Feb 2024 20:14:14 GMT

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.

Re: D365 Business Central scheduled refresh on Power BI Report Server

Anonymous — Thu, 08 Feb 2024 01:27:37 GMT

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.

Re: D365 Business Central scheduled refresh on Power BI Report Server

Taras_WSI — Sat, 10 Feb 2024 00:33:18 GMT

Is there a way to do manual refreshes once report is uploaded onto report server?

Re: D365 Business Central scheduled refresh on Power BI Report Server

josef78 — Mon, 12 Feb 2024 07:46:48 GMT

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

Re: D365 Business Central scheduled refresh on Power BI Report Server

Mahesh0016 — Fri, 12 Jul 2024 10:09:51 GMT

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!

Re: D365 Business Central scheduled refresh on Power BI Report Server

MyNameIsMonk — Fri, 03 Jan 2025 20:30:08 GMT

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).

Re: D365 Business Central scheduled refresh on Power BI Report Server

kcwilsonii1 — Wed, 29 Jul 2026 17:46:45 GMT

that's insane and appears to be done on purpose