Forum Discussion

A-E's avatar
A-E
Frequent Visitor
3 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

Hi, v-yueyunzh-msft. This part has already been done. We have change the data source and it work in desktop and in workspace nr1 when its published there. It is only in the app workspace that it won't refresh and update to that data set. Do we have to remake the app if we make changes to the original data set?

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

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