Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
We have two workspaces (lets say WS1 and WS2). We keep our datasets in WS1 and reports (based on these datasets) in WS2. This was fine until recently, where I tried to update and re-publish a report to WS2, but Power BI Desktop now only gives me WS1 as an option when I go to publish.
As far as I'm aware nothing significant has changed. Any ideas, please?
Solved! Go to Solution.
Hi @apt108 ,
How do you keep datasets in WS1 and reports in WS2? Connecting datasets on Power BI Service with Power BI Desktop? Or using datasets across workspaces?
If you are connectiong datasets on Power BI Service, you may take a look at the considerations-and-limitations .
If you are using datasets across workspaces, please check whether the "Use datasets across workspace" in tenant setting was turn off. If you turn off this setting, here are the effects on report creators:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-admin-across-workspaces
Best Regards,
Jay
Hi @apt108 ,
How do you keep datasets in WS1 and reports in WS2? Connecting datasets on Power BI Service with Power BI Desktop? Or using datasets across workspaces?
If you are connectiong datasets on Power BI Service, you may take a look at the considerations-and-limitations .
If you are using datasets across workspaces, please check whether the "Use datasets across workspace" in tenant setting was turn off. If you turn off this setting, here are the effects on report creators:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-admin-across-workspaces
Best Regards,
Jay
Many thanks Jay, it seems that (unbeknown to me) the "Use datasets across workspace" had been turned off. It's a shame users like me don't have visibility of this setting as it has a direct effect on my work.
Thanks again
Andy
Hi @apt
It looks like this account you're using on Power BI desktop is not a member of WS2. If you log in to Power BI service with the same account, take a look at the Workspaces that account has access to, it's probably just WS1 not WS2. If you do see WS1 and WS2 it's probable that the account is just a "Viewer" of WS2. In either case you'll need to find the Admin of WS2 and get them to add the account as a "Member" or "Contributor" of the workspace.
Alternatively, the Power BI admin can manage the Workspace access and add the account back in, if you can't find the admin of the workspace, or if you were the admin of the workspace.
Hope this helps
Stuart
Many thanks Stewart, but I've already checked that. I'm an Admin of both WS1 and WS2!
This arrangement was working fine until recently, so I'm looking for ideas of what might have changed.
Any other ideas?
Andy