Unable to Refresh Dashboard in Power BI services which uses Sharepoint Excel file as Data Source

[KaviKumaran0001]

Hi,

I have connected multiple Dashboards to Sharepoint Excel Files using Sharepoint Excel Link. However Refreshing the dashboards in Power BI Services Does not work.

No Matter how many times I press Refresh button, It does not refresh. as you can see the Last Refresh Date does not change in below image

So everytime I need to open Power BI Desktop to refresh the dashboard, everytime I refresh in Power BI Desktop, I asks me to sign in again even though I am already signed in to Power BI Desktop.

So I sign in again and connect to the data source, then refresh and re publish the dashboard again.

I want to avoid this since I am handling Multiple Dashboards and I want to be able to directly Refresh the dashboard in Power Bi Services.

[KaviKumaran0001]

Actually Desktop version ask me to login everytime I open the dashboard and click on refresh, I need to login to my organization account and then refresh it .. how to fix this? I have also shared the screenshot above showing error when I try to configure refresh

[KaviKumaran0001]

I get this error when I click on Sign in this Window after selecting "OAuth2" and "Organizational"

[christinepayton]

The refresh button you are using only reloads the page, it does not refresh the dataset. Here's instructions for how to schedule refresh for file and folder datasources in SharePoint: https://youtu.be/ba1Akv63GDQ

The desktop shouldn't ask you to log in every time as long as you are using the same file, assuming you are connecting successfully with the connect button there and saving (e.g. not downloading a fresh copy from the web app). You might try resetting datasource permissions and starting fresh with credenitals though if it's giving you trouble. 

[KaviKumaran0001]

I get this error when I click on Sign in this Window after selecting "OAuth2" and "Organizational"

Actually Desktop version ask me to login everytime I open the dashboard and click on refresh, I need to login to my organization account and then refresh it .. how to fix this? I have also shared the screenshot above showing error when I try to configure refresh

[christinepayton · Accepted solution]

That's strange, I haven't seen it do that before, but someone here is having a similar problem and switching browsers fixed it? https://powerusers.microsoft.com/t5/Power-Query/Data-Source-Credential-error-upon-using-OAuth-2-0-to... 

[KaviKumaran0001]

Hi Christine,

I believe the Issue is Fixed after I enable Pop Up for Power Bi website in Mozilla Firefox! But I will check and come back if I face any issue. If I dont come back, it means the Issue if Fixed by Pop Up activation and Logging to Oauth2 - Organizational