"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
Go to 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.
View solution in original post
Any pointers from you Mr @meysun or someone from your team ?
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
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.
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.