Skip to main content
cancel
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.

Reply
kroman
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? 

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

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