How to use same dataset for multiple report?

0
votes

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?

2
datasetpowerbipowerbi-desktoppowerbi-datasource
By creating a live connection to Power BI service Get Data\Power Bi Datasets – Nick Krasnov
I may need to publish a report along with dataset since I didn't provide with server machine to get live connection to Power BI Service account. I have already published 1 report with the dataset, now I need to use the same dataset for another report as well. – Wanna Coffee
Server machine? You don't need a server machine for that. You publish a report along with its dataset, then create a new one, but instead of importing excel files you connect to the already published into Power Bi service dataset. Performance might suffer a little bit, though.Get Data\Power Bi Datasets choose a dataset you want to connect to and that's it. Find out more – Nick Krasnov
Yes got it, Thank you... Actually, I can get an option for Power BI Datasets under Get Data\Power BI\Power BI datasets – Wanna Coffee
Yes, the full path to the Power BI datasets depends on the PBI version. In the latest one, Power BI datasets can be found under Power Platform. In earlier ones, it might be Power BI or Online Services or something else. I usually use search. – Nick Krasnov

2 Answers

2
votes

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

1
votes

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