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 ,

When you publish the report created in Power BI Desktop to the Power BI Service, you need to set the data credentials for the dataset in the Power BI Service, because Power BI need access the data source with this credential and get the latest data from data source.

Please set your data credential in dataset->settings->datasource credentials.

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 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! 🙂