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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
v_mark
Helper V
Helper V

Scheduled refresh is disabled because at least one data source is missing credentials.

My data source is Active Directory and a CSV file located in Business Onedrive 
Refresh is working in the Power BI Desktop. I even clear the permissions both in AD and on Business Onedrive and republish the report. But still getting the same error message before 

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.
Cluster URI:	WABI-US-NORTH-CENTRAL-redirect.analysis.windows.net
Activity ID:	9e99b221-e0a6-496e-af1a-55e2694f7901
Request ID:	731c696c-e852-2e0e-7dc5-8f0119eb537e
Time:	2021-12-20 15:40:57Z

 
So my question is. Do I need to set up a gateway for connecting in Active Directory and Onedrive? 
If yes, Is there another way to resolve this issue aside from using a gateway?

TIA

1 ACCEPTED SOLUTION
v_mark
Helper V
Helper V

I tried to create a sample one of the report.
Found out that For One drive no gateway need 
but for Active Directory Yes ( Personal Gateway ) this is what PBI Service is throwing at me when I tried to do an on-demand refresh. I setup the gateway looks everything is working fine 

View solution in original post

3 REPLIES 3
v_mark
Helper V
Helper V

I tried to create a sample one of the report.
Found out that For One drive no gateway need 
but for Active Directory Yes ( Personal Gateway ) this is what PBI Service is throwing at me when I tried to do an on-demand refresh. I setup the gateway looks everything is working fine 

Yeah, I meant no gateway for one drive. Glad you were able to figure it out!

Shahfaisal
Solution Sage
Solution Sage

I believe you just need to re-enter the credentials. You don't need gateway for cloud data sources.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors