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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register 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
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

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