Analysis services and sharepoint

[Anonymous]

the current reporting is connecting to analysis services tabluar model which brings the data from SQL server. Also, need to bring the data from sharepoint online/sharepoint folder. the problem is with bringing sahrepoint data in to analysis services data model is every one hour the token is expiring and need to reconnect.

what is the best approach to bring the sharepoint online and sharepoint data to analysis services tabluar model. any thoughts and suggestions would really help? 

[v-xicai]

Hi @Anonymous ,

If you want to connect to SharePoint online folder in Power BI Desktop, please use SharePoint Folder connector and use the URL as below, and choose organizational account method .

https://xxxxx.sharepoint.com/sites/<sitename>

In addition, the Incremental refresh can significantly reduce data refresh duration, especially for large model tables. See more: Incremental refresh in Power BI Premium .

You may try to improve the performance for the data model, see Power BI performance best practices , Power BI Performance Tips and Techniques.

Best Regards,

Amy

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.