Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Hexekutive

Can't save dataflow - Dynamic Source

Submitted by Advocate II on ‎05-06-2021 07:10 AM

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
See more ideas labeled with:
3 Comments (3 New)
Comments
v-lili6-msft
Community Support
Community Support
‎05-06-2021 07:50 PM

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 II
Advocate II
‎05-07-2021 01:38 AM

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.

RenéWindmüller
New Member
‎08-03-2022 04:48 AM

Hello Community,
I have the exact same issue with dynamic OData feed.

Is there any solution for that issue?

Idea Statuses