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

Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!

Reply
kroman
Helper II
Helper II

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? 

Thanks

2 REPLIES 2
sergej_og
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 = [....] ]
https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-i...

You can edit this stuff via Tabular Editor

I am getting list of teams calls via following link 

"https://graph.microsoft.com/v1.0/communications/callRecords/getDirectRoutingCalls(fromDateTime="&DateTime.ToText(DateFromP,"yyyy-MM-dd")&",toDateTime="&DateTime.ToText(DateToP,"yyyy-MM-dd")&")"

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

Announcements
Sticker Challenge 2026 Carousel

Join our Community Sticker Challenge 2026

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

January Power BI Update Carousel

Power BI Monthly Update - January 2026

Check out the January 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.