Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, I've recently begun to use OData calls for pulling data from Microsoft CRM. I'm currently using a programmatically created DataTime value to filter an EmailSet by the last 30 days. This pulls data to PowerBI Desktop as expected, but whenever I try to publish to PowerBI Online, it seems that it has a problem with Text.Combine. As it will work if I do not use it and use a static String. However, if I use the dynamic (programmatically created) string it always says: "You can't schedule refresh for this dataset because one or more sources currently don't support refresh."
If there is a way to circumvent this or another way to do it, any information would be appreciated.
Solved! Go to Solution.
@SmallCityGuy Perhaps easiest way to do is create a calculated column using below code and use that in slicer to filter.
Column = IF(YourTable[EmailDateColumn] < (TODAY()-30),"less than 30 days","not less than 30 days")
This way you won't have to worry about any data refresh issue.
@SmallCityGuy Perhaps easiest way to do is create a calculated column using below code and use that in slicer to filter.
Column = IF(YourTable[EmailDateColumn] < (TODAY()-30),"less than 30 days","not less than 30 days")
This way you won't have to worry about any data refresh issue.
Thanks, It seems that this will inevitably be the way that I'll end up doing it. The my reasoning for the OData filter is so that I don't have to download so much data into PowerBI, in the hopes to reduce the time it take to refresh. Now I'll most likely just have to hardcode a date in where needed (and update every month).