Forum Discussion

rickyringler's avatar
rickyringler
Regular Visitor
2 years ago
Solved

Unknown Power BI Error

My organization received this error, unexpectedly, when attempting to update a .PBIX in production.   ServerError_DataflowWithMultipleWorkspacesUserException   Has anyone ever seen this exception...
  • rickyringler's avatar
    rickyringler
    2 years ago

    The solution: Do not use dataflows. Honestly, if your company is small enough and you are also a software dev or data engineer, just make your own dashboarding tool and scrap Power BI altogether.

    We had one dataflow that queried ~12 static files. We broke this dataflow out, in a new workspace, so each query had their own dataflow.

     

    Old dataflow: One large dataflow. Many queries.

    New dataflows: Many dataflows, one query each.

     

    When I created the new, distinct dataflows, I forgot to change the workspace ID. APPARENTLY you can call a dataflow from ANY workspace ID, even if the dataflow isn't housed in that workspace, and you'll still get the data you need. Why? Microsoft.

     

    So, yeah, the error is quite literal in that you cannot query dataflows from more than one workspace. Albeit, if you are NOT a software developer or data engineer, you might as well read Egyptian hieroglyphics, because that is at least legible compared to Microsoft errors and exceptions.