Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
Hi @dixieduke,
For online service providers, refresh usually occurs once-a-day. This is an Automatic refresh. If you configure a scheduled refresh for data source, it will refresh on the specific time points. And for both of free and pro licenses, refresh frequency only supports up to 8 times per day. Reference: Data refresh in Power BI
Best regards,
Yuliana Gu
Hi @dixieduke,
For online service providers, refresh usually occurs once-a-day. This is an Automatic refresh. If you configure a scheduled refresh for data source, it will refresh on the specific time points. And for both of free and pro licenses, refresh frequency only supports up to 8 times per day. Reference: Data refresh in Power BI
Best regards,
Yuliana Gu
Hi @v-yulgu-msft and @dixieduke
I am working with Odata source of a D365 environment and i am facing some data refresh issues. The time taken by a table with over 600,000 records is over 2 hours to refresh.
that table involves steps where i need to expand on one of the columns (Query Folding or Unfolding).
I believe that this expanding happens row by row and hence the report refreshes very *VERY* slowly.
I would like to know how to fix this, since my data is not on premise but in the Microsoft D365 environment itself. So technically it should refresh faster since both the Power BI service and D365 is on Azure or cloud storage.
If someone can throw some light on this it would be really great. The documentation for PowerBI and D365 is really not helpful here.
Thanks in advance.
Hi
Did you solve the delay in refresh, I use xmr to create XML, merging the tables outside of powerbi and only bringing in columns I needed. It would interesting to know if this solution would also allow auto refresh..
Nope, Microsoft advises me to use Azure SQL or use a Bring your own Database connected to the D365 environment. Azure SQL is faster and can help with long and large tables a lot.
However this also pushes Micorsoft to have money minting model, because apart from the 20k$ / year we pay for the enterprise D365, we now also pay for the extra Azure SQL storage.
They have not released "support" for exporting data to on-premise SQL servers or dbs yer, and most likely will not as they do not make money via it.
Hi @Vi
I have been pointed in the direction of XrmToolBox which enabled me to link and reduce the tables down.
Hope this helps
Lee
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |