Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Visuals not refreshing with sharepoint connection

I have an Excel-file that I want to visualize in Power BI. It is located on Sharepoint, so to get it into Power BI, I simply copied the link to the file on sharepoint, removed everything past the .xl...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

Anonymous: is the default authentication method

Basic: need you enter the account and password

OAuth2: please refer these documents: An Introduction to OAuth 2, Oauth2 Authentication, oAuth Authorization VS Authentication

For privacy level, please refer these documents: Understand Power BI Desktop privacy levels - Power BI | Microsoft Learn, Privacy Levels for Cloud Data Sources | Microsoft Power BI Blog | Microsoft Power BI

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks! With anonymous it didn't work, but when i selected OAuth2 It worked. 

Lovely to see that the PBI Service reports also get updated automatically when I update data in the excel. Thanks for your help! 🙂