Forum Discussion

A-E's avatar
A-E
Frequent Visitor
2 years ago

Updating the app data set?

So we have created an app with a data set which lies in workspace nr 1. This feeds in to the data set which exists in the app and the app workspace (which we can call workspace nr 2) through direct q...
Need Help
A-E's avatar
A-E
Frequent Visitor
2 years ago

Yes, that was our plan as well but PBI wont let us download the data set in the app (or the reports).

 

We have also tried uploading a new version from an old report that has the DirectQuery-link but then it either uploads a copy data set or connects directly to the data set in workspace 1 instead of updating the data set in the app.

 

We might try to upload old versions of reports with a direct link to the data set in workspace 1. I dont really know why a second data set (in the app) was created when we made the app.

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community Support
2 years ago

Hi , A-E 

Thanks for your quick response!  For this question ". I dont really know why a second data set (in the app) was created when we made the app.".

In the normal situation, we connect the dataset using live connection , and when we publish the report , it will just create a report and will not create another dataset based on it .

And if you use the Direct Query mode to connect to the raw dataset , when you publish it , it will create a report and another dataset based on your raw dataset.This is due to it create the data structure in the pbix file so it need to create a new dataset instead of directly live connecting to your raw dataset.

DirectQuery for Power BI dataset: How does it work? - RADACAD

 

And if you can not download this pbix file , you may try to :
(1)Reconnect your dataset, then connect all your previous data sources, and then copy the current report in your workspace No.2 (to prevent the report you created from disappearing). Then change your local .pbix file to the same name and republish it. [If you know how to create this .pbix file , you can use this method.]

(2)If you want to get this .pbix file , you can try this method if it can help you (This may need to have a Premium capcity with XMLA endpoint and external tools). 

Copy Power BI data model back to PBIX file - thinkBI

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly