Query Folding in Dynamics 365 CRM

Hi Lydia,

I'm afraid that unchecking those settings didn't work. If anything it took longer; previously the refresh had taken around two hours, after unchecking those settings it took somewhere between 2 hr 20min and 2hr 40 min (hard to be exact because unless your watching the screen when the refresh finishes there's no way to tell the exact time that it finished).

I am astonished that it takes this long. Power BI is the recommended reporting platform for Dynamics 365 and my main data table is just over a million records, which I keep reading is not supposed to be a problem for Power BI. And in some ways it's not. Once the data has been downloaded the measures calculate very quickly so having a million plus rows IN in the model isn't a problem - it's getting them there that is so painful. The model fails to autorefresh when uploaded to the PBI Service and I've been told by two support engineers from Microsoft that this is because it takes more than 58 minutes. After that, apparently, unless you have the Premium license your security token expires and the refresh fails. How can Microsoft recommend a reporting platform that isn't going to work for people who can’t afford Premium – which is most of the target market for Dynamics 365 and Power BI?

Very unhappy!