Forum Discussion
Refresh all not refreshing datasource tables
Hi Guys,
I have List Query as parameter and from it i am setting parameter for user.
Datasource for this query is coming from blobstorage.
Why I have to go to Transfrom Data --> Edit --> Refresh All and can not use just Refresh button in power bi home view?
Only refreshing all dataSources in power query within power bi desktop is making new item in the parameter list available.
Can anybody explain why?
Best,
Jacek
If you want to enforce meta data synchronization that is the only way (apart from making code changes). The Power BI part doesn't know if/when meta data changes happen.
4 Replies
If you want to enforce meta data synchronization that is the only way (apart from making code changes). The Power BI part doesn't know if/when meta data changes happen.
Hi jaryszek ,
Thank you for reaching out to the Microsoft Fabric Community.
As lbendlin mentioned, the Refresh button in Power BI Desktop only refreshes data, not metadata (such as updated parameter values). To refresh both the data and metadata, you need to use Refresh All within the Power Query Editor. This ensures that new parameter values from your source, like Blob Storage, are properly detected.
If you frequently work with dynamic data sources, we recommend loading the list query directly as a table in the model to avoid manual metadata refreshes. This can help streamline the process and allow for more flexible interactions with your data.
If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thankyou.
