Split PBIX sheets(Tabs) into individual reports

Hello everyone,

I have a PowerBI .pbix file that consists of 20 individual sheets(Tabs). Every Sheet(tab) in .pbix file represents an individual Report.

What I want to do ?
I would like to separate these sheets(Tabs) and have them as individual reports so that I can later publish them onto the PowerBI Cloud service in form of an APP.

Why I want to do this?
I need to do this to build a better App and be able to split and categorize Reports(Tabs) under specific Sub-categories.

Is this possible? If so, how can I achieve this?

Appreciate your support.

Hi @TU4ME,
Thank you very much for posting your question in the forum.
You could use the File Save as a pbix file option to generate each of the full pbix copies and then leave the tabs that correspond to each generated pbix file.

Regards

Hi @jafernandezpuga ,

Could you please explain more? at the end my Data set will be the one from the original .PBIX file or I am missing something? ( I put my .PBIX file on One drive and use get the file from OneDrive for Business to build the App)

Thanks

1 Like

Hi @TU4ME

I think what @jafernandezpuga is meaning, forgive me if I’m wrong, is to keep you main file together as I suspect you have a data model that servces all of the individual reports?

When it comes to publishing the individual reports, simply save down a copy with the name that you want “Report 1” and then remove all the tabs/pages you don’t want in this report. Then publish to your app.

Repeat this step for “Report 2” and so on.

Thanks

DJ

1 Like

Hi @TU4ME,
If you want to have a single dataset for the 20 reports you want to generate, you can follow these steps:

  1. Backup your pbix file that contains all 20 pages.
    Copy fullreport.pbix as fullreport_copy.pbix
  2. Open your fullreport.pbix file and save it as report_dataset.pbix and remove all pages and visuals from page 1, to leave just the dataset.
  3. Publish report_dataset.pbix to your workspace.
  4. Open fullreport.pbix and under Transform Data, delete all queries. This will cause all the visuals to break, but once we switch to Get Data and connect to the Power BI Dataset we published earlier (report_dataset), they should show again.
    We now have the original report for which we have changed the data source from local to Live Connection.
  5. From this pbix connected to a Power BI dataset, you can follow the save as process to generate all 20 reports sharing the same dataset.

Convert a Power BI imported model to Live Connected : Support (tygraph.com)

Regards

2 Likes

Hello @TU4ME,

Did the response from @jafernandezpuga help solve your query?

If not, can you let us know where you’re stuck and what additional assistance you need?

If it did, please mark his answer as the SOLUTION.

Thank you

Hello @TU4ME ,

Due to the length by which this post has been active, we are tagging it as Solved.

Thanks to the contributors of this post.

For further questions related to this post, please make a new thread. Please feel free to reopen this thread if anyone would like to answer the pending inquiry above.

Thank you