How to seperate report from data model

[Anonymous]

Hello everyone,

I am quite new to environment so this question may be very easy.

I have a quite complex and big data model and created several report based same model via Get Data-PowerBI Dataset
But in the beginning-before I publish it to PowerBI app- I created a report on it. Afterwards I use it as a source for other reports. So other reports size is around 15kb-20kb but source has 150mb since it holds views,tables etc.
Now I want to seperate first report from the model and save it as dependent report like other reports?

Is there a way to make it instead of creating new report and do same report all over again?

Thanks in advance,

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

To save the report as a pbix should help you. Please refer to the online document.

https://docs.microsoft.com/en-us/power-bi/service-export-to-pbix

In your scenario, to find the report that you can download is the key point. The report must have been created by using Power BI Desktop and published to the Power BI service, or the .pbix file must have been uploaded to the Power BI service.

[AnthonyTilley]

you can achive this by swapping the data source.

To do this open the orginal report and save as a new version (will need a diffrent name so doesnt over write the dataset)

go to transform data

delete all the tables 

click close an apply 

your report will reload and everything will say error 

go to get data and select bi datamodel 

when you click apply your report should reload with he new data set 

let me know if you get any issues