Forum Discussion
Unknown Power BI Error
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.
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.
Hey rickyringler ,
you are my hero!
There was a query in my ETL process where I had not entered the WorkspaceID correctly.
As you described, the data was still loaded correctly in the desktop version. Only the publishing did not work.
After I adjusted the ID of the workspace, publishing works again.
Thank you!
Best regards