Small and medium business | Business Central, N...

Refresh failed to Get General Ledger Entries with Dimensions to Power BI

(0) Share

Report

Posted on by mahmoud_algindy

277

Dear Experts,

I'm currently working on Power BI Reports and most of the reports are built on

General Ledger Entries with Dimensions

Query Object ID 2403

I tried Power BI Dataflows and Power platform Dataflows and even Power BI Desktop to get the data.

I tried some AL code to group the data and it's great as it reduced the 7M rows to only 50K rows but still the same all the time getting Refresh errors, like: Time out, very large dataset & etc.

Error: Refreshing an entity exceeded the 2 hour refresh limit. Request ID: *** Activity ID: ****

could someone help, I also used the preview features:

and changed the Data Intent Access to Read Only

But nothing changed, how to solve this issue?

All responses (2)

Answers (0)

Suggested answer

YUN ZHU 81,780 Super User 2025 Season 1 on at

Like (1)

Report

RE: Refresh failed to Get General Ledger Entries with Dimensions to Power BI

Hi, If you are using Query, you may have used Web Service.

The following are OData request limits (per environment)

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/operational-limits-online#ODataServices

First of all I suggest using APIs, its performance is much higher than Odata.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-api-pagetype

Also, you can append some filters to your links to reduce the number of fetches, which should improve performance a bit.

https://yzhums.com/6117/#toc8

Hope this helps.

Thanks

ZHU
Suggested answer

DAnny3211 9,276 Moderator on at

Like (0)

Report

RE: Refresh failed to Get General Ledger Entries with Dimensions to Power BI

hi

look this info

community.dynamics.com/.../data-model-in-power-bi-and-dimension-set-id

DAniele