Forum Discussion

Djorran's avatar
Djorran
Regular Visitor
10 years ago

Schedule data refresh OData with parameter

Hi, I wonder if someone knows a way to schedule a data refresh from Power BI with an OData query that have a parameter in it's url? Both these urls works fine from the Power BI desktop but after up...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi,

My issue is similar if not identical. I am connecting to OData v 4.0

 

I need to fetch records since two Sundays ago from current date and also filter to get only a few columns. So, I used a parameter for the report start date, externalized the source URL, used Text.Combine() to construct the URL in the Advanced Editor.

 

Something like this:

URL = Text.Combine({CRMODataConnectString,"/leads?$select=column1,column2,column3, ... ,columnN&$filter=columnX gt ",ReportStartDate},""),

 

But ever since I moved to

 

Source = OData.Feed(URL)

I am not able to refresh on the Power BI service. I get an error that schedule refresh is not supported for this Source. 

 

 

 

 

 

 

 

 

 

 

 

I don't even get the usual sub menus under schedule refresh - like Gateway connection, Data Source Credentials and Schedule Refresh.

 

 

On Power BI desktop, it is faster than ever due to the filters.