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: 1. I'm connecting PBI desktop to D365 using the Odata feed, similar to what you see here https://www.powerobjects.com/2016/11/18/connect-to-dynamics-365-data-from-powerbi-desktop/ 2. I'm creating visuals in PBI desktop, and publishing those to the PBI service. 3. I have PBI Pro. The question is, how often will the visuals (published to PBI service from PBI desktop) refresh to reflect the most current D365 data? I did find somewhere that it occurs once a day. I also saw where you could refresh the D365 data up to 8 times a day with the PBI pro acct, but I wasn't sure if that was only in the context of connecting the PBI service visuals to the D365 data pack--which isn't what I'm doing. Thanks for the help.
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

5 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    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
      7 years ago

      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.

      List of steps i need to include for the large table in order to get my required data.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

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