Scheduled Refresh Issue - Text.Combine - PowerBI Desktop PowerQuery (Advanced Editor) - OData

[SmallCityGuy]

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.

[ankitpatira · Accepted 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]

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).