Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
Solved! Go to Solution.
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
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!
I believe you just need to re-enter the credentials. You don't need gateway for cloud data sources.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
28 | |
26 | |
22 | |
22 | |
18 |
User | Count |
---|---|
51 | |
34 | |
28 | |
24 | |
21 |