Forum Discussion
acanepa
8 years agoResolver I
Share Dataset across workspaces
Hello, I have a report that holds core data and I want to consume that information from other workspaces. Let's says that the report is in Workspace A and I want to push the data to Workspace B. ...
- Anonymous8 years ago
Hi acanepa,
Nope, if your datasource is get from power bi service reports, you can only publish to same workspace.
Reference link:
Connect to datasets in the Power BI service from Power BI Desktop
Limitations and considerations
When using the Power BI service live connection, there are a few limitations and considerations to keep in mind.
- Read-only members of a workspace cannot connect to datasets from Power BI Desktop.
- Only users who are part of the same Power BI service workspace can connect to a published dataset using the Power BI service live connection. Users can (and often do) belong to more than one workspace.
- Since this is a live connection, left-navigation and modeling are disabled, similar to the behavior when connected to SQL Server Analysis Services.
- Since this is a live connection, RLS (row- and role-level security), OneDrive for Business, and other such connection behaviors are enforced, just as they are when connected to SQL Server Analysis Services.
- When selecting which dataset to connect to in the Power BI service, the search box only applies to workspaces that have been expanded.
- If you modify the original shared .pbix file, the dataset and report that is shared in the Power BI service is overwritten.
- You cannot replace the originally shared report. Attempts to do so result in a warning that prompts you to rename the file, and publish.
- If you delete the shared dataset in the Power BI service, then other Power BI Desktop (.pbix files) will no longer work properly or display their visuals.
- For Content Packs, you must first create a copy of a content pack before using it as a basis for sharing a .pbix report and dataset to the Power BI service.
- For Content Packs from My Organization, once copied, you cannot replace the report created on the service and/or a report created as part of copying a Content Pack with a live connection. Attempts to do so result in a warning that prompts you to rename the file, and publish. In this situation, you can only replace published live connected reports.
- When you create a report based on dataset using a live connection to the Power BI service, you can only publish that report to the same Power BI service workspace that contains the dataset being used.
- Deleting a shared dataset in the Power BI service means you can no longer access that dataset from Power BI Desktop.
Regards,
Xiaoxin Sheng
Anonymous
8 years agoNot applicable
I know this is marked as Solved and unavailable but did you find any workaround for this? I'm facing the same problem
- acanepa8 years agoResolver I
Hi Anonymous,
I ended up using PowerBI live connection, mainly because I couldn't find other solution and it works pretty well with Row Level Security. That comes with the downsize that PowerBI Live Connection is the only data you could load in a PowerBI workbook.
Regards,