Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper I
Helper I

Updating workspace dataset without desktop PBI

Hi All

I looking for a way to update datset in a workspace other then via opening report in a powerbi desktop and republishing it (just need to change few parameters that uset in datasource filtering)
I manage to update it via power BI API, but after the update dataset stops refreshing with error "This dataset includes a dynamic data source. Since dynamic data sources aren't refreshed in the Power BI service, this dataset won't be refreshed" - is there any way to sort this problem? 


Super User
Super User

The way I see it you want to make PQ adjustments? Am I right?
If yes, you can use Tabular Editor,  connect to your model directly online via XMLA Endpoint.
Choose your target table and look for partitions in this table.
Normally you can see the M code there.

Dynamic datasource seems to be another issue?
You have to split your URL into separate pieces.
Maybe this way [Relative Path = "xxxx", Query = [....] ]

You can edit this stuff via Tabular Editor

I am getting list of teams calls via following link 


Where "DateFromP" and "DateToP" parameters, which I want to change without using power bi desktop (something simple where user just click the link or button etc , as I mentioned I tried to do it via PBI API, but after update it refuses to refresh 😞 )   

Helpful resources


Fabric certifications survey

Certification feedback opportunity for the community.


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors