cancel
Showing results for 
Search instead for 
Did you mean: 

Can't save dataflow - Dynamic Source

Dear community,

 

I have been trying to call an oData source using a paginated query. It works like charm in Power BI Desktop, but I'm having some issues in the Service. 

 

My query has a function, and as already mentioned in this forum it is disabled for loading.

 

However, I keep getting the error. Below all the facts. Many thanks in advance for your help.

 

Hexekutive_0-1620310140455.png

 

The query:

Hexekutive_2-1620310184470.png

 

The error:

 

Hexekutive_1-1620310169244.png

 

The query works fine when I pass the parameters to it within the editor, but doesn't let me save.

Status: New
Comments
v-lili6-msft
Community Support

hi

Take a look at this blog for how to use the query option available in web.contents

https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-i...

 

 

Regards,

Lin

Hexekutive
Advocate I

HI @v-lili6-msft,

 

Many thanks for your answer. I tried RelativePath as suggested in another post, but my query is Private, so I received an error message saying that RelativePath cannot be used with Private data sources. Also my query is oData, not Web.Contents.