Reducing Dataset Refresh Time with Microsoft Dynamics 365

Challenge:  

NSquare Xperts used SharePoint as a dataset in which the client had over 400,000 records to create a Power BI report. However, when the data was refreshed to obtain the most recent information from SharePoint to Power BI, the process took longer than usual and eventually showed a timeout error. 

Solution:  

Process: SharePoint To Microsoft Power BI 

Through Power BI’s Get Data option, we could connect SharePoint and import data into Microsoft Power BI. This is the first step to creating a connection between SharePoint and Microsoft Power BI. Once this is done, the user can then generate reports and dashboards with visuals and charts. 

To address this issue, NSquare Xperts implemented a dataflow within the Power BI Service. 

Steps that we followed to Create a Dataflow in Power BI Service:  

Outcome: 

  • Faster Refresh: Using a dataflow significantly reduced the refresh time from hours to less than a minute. 
  • Scalability: Dataflows can handle the load efficiently as your dataset increases. 

Conclusion: 

To minimize the refresh time, NSquare Xperts created a dataflow in Power BI Service which remarkably dropped it from 4-5 hours to less than a minute. This resulted in faster insights and improved efficiency. 

Client Profile:  

The client is a facilities management company that provides a holistic and integrated facilities management solution in the UAE. 

Technologies Supported:  

  • Microsoft Dynamics 365  
  • Microsoft Power BI  
  • SharePoint 

Leave a Reply

Your email address will not be published. Required fields are marked *