cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate IV
Advocate IV

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

"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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Advocate IV
Advocate IV

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

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

View solution in original post

4 REPLIES 4
Highlighted
Advocate IV
Advocate IV

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

Highlighted
Community Support
Community Support

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

 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted

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.

Highlighted
Advocate IV
Advocate IV

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

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

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors