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

Thanks for the instructions Anonymous!

When I click on "edit credentials", I get three options:

-Anonymous

-Basic

-OAuth2

Which one should I choose, and are there any differences?

 

Also, I get to choose of 4 different privacy levels: none, private, organizational, public.

What to go with?

The report should be available to everyone within our company I believe. 

 

Thanks for the 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! 🙂