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
Chris2B
Helper I
Helper I

Schedule Refresh

HI I need some help please.

 

I am trying to refresh a dataset that I have uploaded onto the server but everytime I try to refresh I get this error:

 

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-UK-SOUTH-redirect.analysis.windows.net
Activity ID: aabd8c08-694c-4a13-90ff-d20ef3e7ebb0
Request ID: 6ded4329-af52-dfe4-8924-7e93c34c3d5c
Time: 2023-06-20 13:14:34Z

 

Does anyone have a workaround please.

 

KR,

 

Chris

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

Hi @Chris2B 

 

I would suggest making sure that you can refresh the dataset successfully before looking to add visuals?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

4 REPLIES 4
pthapa
Resolver I
Resolver I

Hi @Chris2B ,
Anytime you add new data connections to your model, you will have to provide the credentials on your gateway and connections settings and provide the authentication required.
For this follow these steps:

1. Go to Settings on power bi service to the far right (Gear icon)

2. Manage connections and gateways

3. Connections (this will list all of your connections)

4. Click on refresh icon to the right that says 'Status' and if anyone is showing offline, go to next step.

5. Click on three little dots, then settings

6. Under Authentication - select 'Edit credentials' then choose OAuth 2.0

7. Provide your authentications

8. Privacy level - choose Organizational (based on your situations)

9. Save

10. Now go adhead and check the Status to see if that connection comes online.

11. If they show online, you can refresh entire dataset and you should be good.

Let me know how it comes after you follow these steps.

Thanks,

PT

GilbertQ
Super User
Super User

Hi @Chris2B 

 

I would suggest making sure that you can refresh the dataset successfully before looking to add visuals?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

GilbertQ
Super User
Super User

Hi @Chris2B 

 

As it says you need to enter the data source credentials in order for the dataset to refresh.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Hi @GilbertQ,

 

Thanks for this. I have updated the data source credentials but when I refresh it the report is not updating, if I add new visuals from the Desktop.

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

April Fabric Community Update

Fabric Community Update - April 2024

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

March 2024 PBI Gallery Image

Power BI Monthly Update - March 2024

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

Top Solution Authors
Top Kudoed Authors