Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to seperate report from data model

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,

  • 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.

     

2 Replies

  • 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

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support

    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.