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

Can't sign-in credentials for dataset to resolve the "Scheduled Refresh is Disabled" problem.

I have created a simple visual in Power BI Desktop to test the data syncing feature. It uses a single column, single value table in an Excel file as data and outputs that value to a card visual. When I change the value in the Excel file and refresh in Power BI Desktop, the value updates correctly. However, when I publish it to Power BI Service, the refresh does not work. Here is the dataset error message:

 

"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."
 
I have followed the instructions and tried to "enter credentials" for this single data source. I go to the below window and click "Sign-in" and nothing happens. The animating spinner icon just keeps spinning indefinitely (See below). What am I doing wrong here? Note: I am on my organization's network, and have tried using an excel file from my OneDrive for Business, as well as from a directory in our organization's SharePoint Online folders.

rcarroll_0-1670600222752.png

 

 

1 ACCEPTED SOLUTION

It doesn't matter that it's your OneDrive local folder, the Power BI service can't get to it without the data gateway (but again I wouldn't bother with the gateway, get the data from a SharePoint folder instead of C:).

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
BI Blog: Datamarts | RLS/OLS | Dev Tools | Languages | Aggregations | XMLA/APIs | Field Parameters | Custom Visuals

View solution in original post

4 REPLIES 4
otravers
Super User
Super User

The path in your screenshot is a local drive (C:), not a cloud OneDrive or SharePoint folder. If you stick to the local resource then you'll need to install a data gateway on your PC. The better alternative is to change your data source to the cloud path for your file.

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
BI Blog: Datamarts | RLS/OLS | Dev Tools | Languages | Aggregations | XMLA/APIs | Field Parameters | Custom Visuals

Yes, but the path shows that it’s connecting to my OneDrive folder. Does that not matter? Please continue to bear with me if my understanding is flawed. I really appreciate your time. 

 

I've tried putting it in one of our shared SharePoint folders, but using my local shortcut to that folder (hence the pathway would still show my C: drive). Is it not working because it's pathing through my C drive, and not using a cloud URL to my OneDrive or Sharepoint source?

It doesn't matter that it's your OneDrive local folder, the Power BI service can't get to it without the data gateway (but again I wouldn't bother with the gateway, get the data from a SharePoint folder instead of C:).

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
BI Blog: Datamarts | RLS/OLS | Dev Tools | Languages | Aggregations | XMLA/APIs | Field Parameters | Custom Visuals

Okay, I think I finally understand. I went with the web connector, and linked to the same file via a url to the excel file on Sharepoint. It worked, thank you!

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