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
Betty888
Helper II
Helper II

Planned refresh of published dashboard

Hi all,

I want to publish a Power BI dashboard and I need to plan the data source refresh, but it’s deactivated. I’m receiving a popup saying that at least 1 data source doesn’t have credentials entered.  

I’m using as source 2 databases (SQL database and Amazon redshift), and I want to publish this report in my Workspace.

Additional info, I’m creating this report based on “Import” not “Direct query”.

Can you please help me on how can I connect my workspace to the 2 data sources I’m using in the dashboard to let the refresh works?

Thanks a lot!

2 REPLIES 2
amitchandak
Super User
Super User

@Betty888 , Go to workspace, from the three dots near to dataset open settings.

After that check does if need on-premise gateway, if yes setup that

After that check the data source credentials

 

Power BI Install On-Premise Gateway and configure it on service: https://youtu.be/lObMRofpbQ8

Hi @amitchandak ,

Very many thanks !!!

The video is very useful, I was able to create the gateway and add the SQL server database. It's a very good video , I recommend it to all users. 

Just one additional issue 🙏 in some of my dashboards , I'm connected to 2 databases (SQL and Amazon redshift), but I don't see how can I identify in my gateway 2 different data sources, any insights? 

Thanks again ! 

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.