We have users who use Power BI Desktop with a live, "Power BI datasets" connection to DatasetX. And this DatasetX lives in WorkspaceX. These users are not members of WorkspaceX; but they have "Read, reshare, build" permissions on DatasetX. So they can create reports with the live connection, then publish those reports to a different workspace (one where they are members).
That is, until the last 1-2 days! This scenario just stopped working for us!
The users can still use Power BI Desktop with a live connection to that dataset. This still works like always. The issue is: they are no longer able to publish the .pbix reports to a different workspace. If they try to publish from Power BI Desktop, it says:
Couldn't publish to Power BI
An error occurred while attempting to publish '[ReportZ.pbix]':
The remote server returned and error: (400) Bad Request.
If they try to upload the .pbix file in the (other) workspace, by going to +New > Upload a file > Local File, it says:
Can't publish Power BI Desktop file
Looks like that we're unable to access the dataset. Please contact the owner of the dataset.
But if I add the user to WorkspaceX, where DatasetX resides, then they are able to publish their .pbix "report files" with the live connnection to a different workspace.
Please help! Seems like a significant bug. I believe these users should be able to publish these reports to other workspaces, without needing to be members of WorkspaceX. It always worked, before. Thank you.
v-xiaoyan-msft
on:
Lakehouse table error : Encountered Azure error wh...