Forum Discussion
Updating the app data set?
Hi , A-E
Thanks for your quick response! According to your description, the dataset in your workspace No.1 is re-published and it can refresh normally . Instead the dataset in the Workspace No.2 can not refresh which may caused by the data structure is changed in the raw dataset in workspace No.1.
If this , you need to download your dataset in your Workspace No.2 which is using DirectQuery mode to your raw dataset in workspace No.1.(If you have this .pbix file , you can just check in it). Then you can re-connect the dataset in the Workspace No.1 to check if it can refresh in your desktop.
Before re-publish the dataset to your Workspace No.2, you can first copy your report based on this dataset to a new one:
The "tool2-copy" is copied from "tool2". After copy the same name with this dataset name , then we can re-publish the dataset to Workspace No.2.
Then we can refresh the visual to see if get the newest data in the raw dataset which is in your Workspace No.1.
And if you can get your new data in this dataset , and you also create an app in this workspace , i think you need re-publish the app again to make this app update:
Publish an app in Power BI - Power BI | Microsoft Learn
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
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.
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