Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
"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
Solved! 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.
Well after research and going through blogs , I found out the solution.
Chris has posted solution for similar problem and this is the link.
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
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.