Power BI DataFlow failing without error message

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 Learn

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.