Power BI DataFlow failing without error message

[jashjacob]

I have a few DataFlows that fetch data from Business Central. I was already having trouble with the query getting terminated due to size or duration, but now I have errors with no reason provided. See the error message below:

***********

Error: Request ID: ba3b865d-5d42-4d31-a6dc-745fa11b6727 Activity ID: 1d720802-a3dd-40a6-92a1-8101a6b232d4

**********

Now, I don't even know the reason for failure. However, the ones that failed are similar to the ones that used to time out due to size/duration. 

I have following questions:

 1. How do I obtain the reason for failure for this query?

 2. What are the options available for tuning queries from Business Central?

 3. What is the best way to use Business Central as source?

[Anonymous · Accepted solution]

Hi @jashjacob ,
For the problem you are experiencing, you log in to Business Central and check the error logs to see if there are any relevant errors.
On top of that, you can also check the refresh status of dataflow to see if the query fails due to resource constraints and timeout.

Understand and optimize dataflows refresh - Power BI | Microsoft Learn

Monitoring Business Central Server Events in Event Viewer - Business Central | Microsoft Learn
business central comes with a performance analyser for your needs, here's a resource I found that fits the bill perfectly, hopefully it's helpful!
How to work with a performance problem - Business Central | Microsoft Learn
The following documentation mentions the use of the API and OData Web Services as recommended options, as the API pages have a more efficient and flexible approach.
Building Reports in Power BI Desktop to Display Business Central Data - Business Central | Microsoft...

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.