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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

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

Jan NL Carousel

Fabric Community Update - January 2025

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