Forum Discussion

acanepa's avatar
acanepa
Resolver I
8 years ago
Solved

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. ...
  • Anonymous's avatar
    Anonymous
    8 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