cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ludvigj
Frequent Visitor

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 .xlsx, signed in with my office account, and then clicked connect. I have built a great report, and it has also been published to a workspace. 

 

Today I changed some of the data (marked some rows with X) in the excel, and since the dataset in the workspace is on manual refresh, I clicked refresh there too. Then I went into the report, clicked on refresh visuals, but I still couldnt see a change. 

When I go into the desktop app, I can click refresh and see that I get the latest data on my visuals, but it dosen't work in Power BI service. Only when I published the report to the workspace again did the report in the workspace show the latest data. 

 

Does anyone know what's up with this?

 

The dataset in the workspace has sheduled refresh disabled due to the following message:

Data source error: Scheduled refresh is disabled because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources. Then reactivate scheduled refresh.

Maybe this has to do with the problem I described earlier, but how would I fix it then?

 

Thanks for your help! I really appreciate it 🙂

1 ACCEPTED SOLUTION

Hi @ludvigj ,

Anonymous: is the default authentication method

Basic: need you enter the account and password

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

For privacy level, please refer these documents: Understand Power BI Desktop privacy levels - Power BI | Microsoft LearnPrivacy 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.

 

View solution in original post

5 REPLIES 5
MukeshT
New Member

For that, we have created a power bi report using an excel sheet. Then, we will publish the report online in the power bi service.

Open Power Bi desktop, Now you can see the report page on the power bi desktop.
Now we will publish the report on the web. To publish the report, click on the publish icon on the ribbon on the power bi desktop.
In the Publish to power bi dialog box, under select a destination, click on the My workspace. Click on the Select
Then in the Publishing to Power Bi dialog box, you can see that your power bi report(financial report) successfully published on the power bi web. Then click on Got it.

Now we will schedule a refresh in the power bi service, when we make a change in the report on the power bi desktop, it gets updated on the web.

In the office 365 admin center, Click on the app launcher, then select power bi.
Click on the My Workspace from the navigation in power bi service.
Then go to Dataset+Dataflows on the My workspace page in the power bi service.
Next to the name of the dataset, there is a refresh now icon, by clicking on the refresh icon, you can refresh the report immediately.
Next to the refresh now icon, click on the schedule refresh in the My workspace page in power bi service. Here we are using the financial report to set the schedule refresh.

 

Regards,
Mukesh

v-binbinyu-msft
Community Support
Community Support

Hi @ludvigj ,

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.

vbinbinyumsft_0-1669691546783.png

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.

 

 

Thanks for the instructions @v-binbinyu-msft!

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. 

 

ludvigj_0-1669707239813.png

Thanks for the help! 🙂

Hi @ludvigj ,

Anonymous: is the default authentication method

Basic: need you enter the account and password

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

For privacy level, please refer these documents: Understand Power BI Desktop privacy levels - Power BI | Microsoft LearnPrivacy 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.

 

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

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors