Forum Discussion
Solved
Scheduled Refresh Issue - Text.Combine - PowerBI Desktop PowerQuery (Advanced Editor) - OData
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 d...
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).