Forum Discussion

achinm45's avatar
achinm45
Advocate IV
9 years ago
Solved

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 q...
Need Help
  • achinm45's avatar
    achinm45
    9 years ago

    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's avatar
v-qiuyu-msft
Community Support
9 years ago

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's avatar
achinm45
Advocate IV
9 years ago

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.