Forum Discussion
Helper IIIQuery Folding in Dynamics 365 CRM
Helper IIIHi 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!
Helper IIICan I just confirm something?
At moment my first steps for each table that I import are to remove the columns that I don't need and filter out the rows that I don't need. I am doing this promarily to try and speed the refresh up. Is this pointless? In the absence of query folding does does everything have to be downloaded, all columns and all rows, before antything can be removed? Which means that I can be squeaky clean with best practice but it won't make any difference to the refreesh time?
IanR
It will reduce the refresh time after you remove unwanted columns and rows. And yes, you need to import all columns and rows , then remove the columns and rows you don't need.
Regards,
Lydia