Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Community Champion
Community Champion

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors