Forum Discussion

jaryszek's avatar
jaryszek
Super User
1 year ago
Solved

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 --> Refre...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.