CODEWITHSUNDEEP
datasetpowerbipowerbi-desktoppowerbi-datasource
Wanna Coffee
Wanna Coffee

Reputation: 2796

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?

Upvotes: 0

Views: 4212

Answers (2)

Strawberryshrub
Strawberryshrub

Reputation: 3399

In the query designer you can add a blank query and refer to the importet table. Lets assume the importet table name is Imported Table. Add a blank query:

enter image description here

Write in the expression the table name:

enter image description here

Now you have a copy of your Imported Table:

enter image description here

Upvotes: 1

sqlarcher
sqlarcher

Reputation: 101

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

Upvotes: 2

Related Questions