Search code examples
datasetpowerbipowerbi-desktoppowerbi-datasource

How to use same dataset for multiple report?

Is there a way to use the same dataset for multiple Power BI report.

Let's assume I have excel data source, I will have it imported into Power BI service account as part of report publish. Now I'm creating one more report with the same data source, but this time it creates a new dataset in service account.

How do I can use the same dataset for both of the Power BI report available in same workspace (or) in the different workspace?

Solution

  • You can look into using Power BI Dataflows, or you can use the Shared Datasets which is in preview now.

    Power BI Dataflows

    Shared Datasets (Preview)

    When connecting to these data sets from Power BI Desktop, either choose:

    Get Data -> Power BI datasets

    or

    Get Data -> Power BI dataflows