Cannot schedule refresh for datasource of type OData.Feed from CRM 365

[jmkvalsund]

I use a datasource like this (anonymizing company URL):
Source = OData.Feed("https://mycompany.mysite.dynamics.com/api/data/v9.0/tasks?$"
&"filter=createdon ge " & Date.ToText(Date.AddMonths(Date.From(DateTime.LocalNow()),-18),[Format="yyyy-MM-dd",Culture="en-US"] )
,null, [Implementation="2.0"])

This returns all tasks created in the last 18 month from my CRM 365 database, works fine.

But when I try to set the dataset to scheduled refresh in the Power BI service, I get the message "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 a way to solve this? I have found info about using the RelativePath And Query Options With Web.Contents(), does anyone know if this works using OData.Feed? I haven't got it working so far.....

Anyone who has another solution?

Regards,

John Martin

[v-xiaotang · Accepted solution]

Hi @jmkvalsund 

Thanks for reaching out to us.

First, check whether your dynamic data source can be refreshed, open the Data Source Settings dialog in Power Query Editor, and then select Data Sources In Current File. In the window that appears, look for the following warning message, as shown in the following image:

If that warning is present in the Data Source Settings dialog that appears, then a dynamic data source that cannot be refreshed in the Power BI service is present.

FYI: Data refresh in Power BI - Power BI | Microsoft Docs

(2) if your dynamic data source can be refreshed, then use the RelativePath and Query options with the Web.Contents M function. Queries that reference Power Query parameters can also be refreshed.

FYI:

Solved: Dynamic data sources aren't refreshed in the Power... - Microsoft Power BI Community

Solved: Error while schedule refresh - getting error " Thi... - Microsoft Power BI Community

https://medium.datadriveninvestor.com/setting-a-scheduled-refresh-on-a-dynamic-data-source-in-power-...

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[v-xiaotang · Accepted solution]

Hi @jmkvalsund 

Thanks for reaching out to us.

First, check whether your dynamic data source can be refreshed, open the Data Source Settings dialog in Power Query Editor, and then select Data Sources In Current File. In the window that appears, look for the following warning message, as shown in the following image:

If that warning is present in the Data Source Settings dialog that appears, then a dynamic data source that cannot be refreshed in the Power BI service is present.

FYI: Data refresh in Power BI - Power BI | Microsoft Docs

(2) if your dynamic data source can be refreshed, then use the RelativePath and Query options with the Web.Contents M function. Queries that reference Power Query parameters can also be refreshed.

FYI:

Solved: Dynamic data sources aren't refreshed in the Power... - Microsoft Power BI Community

Solved: Error while schedule refresh - getting error " Thi... - Microsoft Power BI Community

https://medium.datadriveninvestor.com/setting-a-scheduled-refresh-on-a-dynamic-data-source-in-power-...

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[v-xiaotang · Accepted solution]

Hi @jmkvalsund 

Thanks for reaching out to us.

First, check whether your dynamic data source can be refreshed, open the Data Source Settings dialog in Power Query Editor, and then select Data Sources In Current File. In the window that appears, look for the following warning message, as shown in the following image:

If that warning is present in the Data Source Settings dialog that appears, then a dynamic data source that cannot be refreshed in the Power BI service is present.

FYI: Data refresh in Power BI - Power BI | Microsoft Docs

(2) if your dynamic data source can be refreshed, then use the RelativePath and Query options with the Web.Contents M function. Queries that reference Power Query parameters can also be refreshed.

FYI:

Solved: Dynamic data sources aren't refreshed in the Power... - Microsoft Power BI Community

Solved: Error while schedule refresh - getting error " Thi... - Microsoft Power BI Community

https://medium.datadriveninvestor.com/setting-a-scheduled-refresh-on-a-dynamic-data-source-in-power-...

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.