Forum Discussion
Problem with Power Query refresh in Power BI Service (httpStatus :500)
Hi,
Since the data loads successfully for a single database but fails when running for 20 databases, this could be a timeout issue. How much time does it take to extract data from one database?
I suggest trying the following:
Gradually increase the number of databases one at a time (i.e., first run for 1 database, then 2, and so on) and identify the point of failure — specifically, after how many databases the error starts occurring. This could indicate two possibilities:
The error is a timeout issue (in which case, proceed to step 2).
There is an issue fetching data from a particular database. To rule this out, try running the process only for that specific database. If it runs successfully, then this is not the cause, and you can proceed to step 2.
Create separate dataflows for each database (resulting in 20 dataflows). Then use these dataflows as sources, merge them into a single dataflow, and use that for reporting. If you are using Fabric capacity, use Dataflow Gen2; otherwise, use Dataflow Gen1.
_________________________________________________________
If this helped, ✓ Mark as Solution | Kudos appreciated
Hi,
Since the data loads successfully for a single database but fails when running for 20 databases, this could be a timeout issue. How much time does it take to extract data from one database?
I suggest trying the following:
Gradually increase the number of databases one at a time (i.e., first run for 1 database, then 2, and so on) and identify the point of failure — specifically, after how many databases the error starts occurring. This could indicate two possibilities:
The error is a timeout issue (in which case, proceed to step 2).
There is an issue fetching data from a particular database. To rule this out, try running the process only for that specific database. If it runs successfully, then this is not the cause, and you can proceed to step 2.
Create separate dataflows for each database (resulting in 20 dataflows). Then use these dataflows as sources, merge them into a single dataflow, and use that for reporting. If you are using Fabric capacity, use Dataflow Gen2; otherwise, use Dataflow Gen1.
_________________________________________________________
If this helped, ✓ Mark as Solution | Kudos appreciated