Forum Discussion

dixieduke's avatar
dixieduke
Regular Visitor
7 years ago
Solved

PBI Desktop & Dynamics 365 Source (data refresh)

PBI Desktop & Dynamics 365 Source (data refresh) Hello all! I hope you all are having a good day. I researched this topic (here & on the web), but couldn't find a direct answer. Here is some context: ...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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. 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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