Schedule refresh not working for web.contents based query (using CRM Online fetchXML)

[achinm45]

"You can't schedule refresh for this dataset because one or more sources currently don't support refresh"

This is the message I get when I am trying to fetch data from CRM online using multiple queries .

I am using web as source and in it a  fetchxml command to pass on URI

And for every month of data, we have separate query to hit CRM online.

In power BI desktop it all works fine. However, when we try to refresh the data in Power BI online, it throws the error.

I have created queries I need in an excel sheet and have hard coded date ranges in those queries. I am then accessing those URI queries.

My queries are in format :  http:........./incidents?fetchxml =%3e............ <condition>2016-01-01<condition>2016-02-01>.....

Please do help us in providing useful pointers or solution for this

Thanks,

Achin

[achinm45 · Accepted solution]

Well after research and going through blogs , I found out the solution.

Chris has posted solution for similar problem and this is the link.

[v-qiuyu-msft]

Hi @achinm45,

In your scenario, please remove date range filter from the URL. And created a calculated column to

Column = IF(DimDate[FullDateAlternateKey]>DATEVALUE("2001/1/1") && DimDate[FullDateAlternateKey]< DATEVALUE("2003/2/1") ,true,false)

Then place this column in slicer to choose "true" value.  For more information, please refer to this similar thread: Scheduled Refresh Issue - Text.Combine - PowerBI Desktop PowerQuery (Advanced Editor) - OData.

Best Regards,
Qiuyun Yu

[achinm45]

Thanks for replying. However , Issue is in pulling the data . So I need these filters to extract data of relevant period. I have many queries for on same basis and they together pull out large chunk of data which a single query can't pull out.

[achinm45]

Any pointers from you Mr  @meysun or someone from your team ?