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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
marquesjef
Regular Visitor

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

Published a dashboard with my PRO account, but when updating through the platform, the following error appears:

 

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.

 

This dashboard consumes data from a MySQL database, does not have a gateway, and in its settings, the option for database credentials is disabled.

 

Does anyone know how to solve it?"

1 ACCEPTED SOLUTION
v-jianpeng-msft
Community Support
Community Support

Hi, @marquesjef 

LBENDLIN answered very well, you need a gateway. Power Bi Service is connected to your data source through the gateway. Below I will add some detailed steps:

1.Download and install the Power BI Standard Gateway. For detailed installation steps, you can click the connection below:

https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-install

2.When you configure the local gateway, you need to connect to your semantic model through this gateway in Power BI Service.

Click this small gear in the upper right corner

vjianpengmsft_5-1708404436410.png

 

vjianpengmsft_4-1708404405099.png

Click New to create a new connection

vjianpengmsft_6-1708404509309.png

Select your gateway in the Gateway Cluster Name, select mysql in Connection Type, and then fill in your MySQL Server, DataBase, Authentication.

vjianpengmsft_8-1708404698499.png

 

3.When you successfully configure the Connection, you can use this gateway connection for your semantic model through the following steps:

vjianpengmsft_9-1708405189726.png

vjianpengmsft_0-1708406001002.png

 

vjianpengmsft_1-1708406084134.png

Through the above steps, you can configure the gateway connection to your semantic model. After successful configuration, you can use the schedule refresh function normally. For more details, please click the related connection below:

Use the on-premises data gateway app | Microsoft Learn

Add or remove a gateway data source - Power BI | Microsoft Learn

Configure scheduled refresh - Power BI | Microsoft Learn

 

 

 

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

View solution in original post

8 REPLIES 8
v-jianpeng-msft
Community Support
Community Support

Hi, @marquesjef 

LBENDLIN answered very well, you need a gateway. Power Bi Service is connected to your data source through the gateway. Below I will add some detailed steps:

1.Download and install the Power BI Standard Gateway. For detailed installation steps, you can click the connection below:

https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-install

2.When you configure the local gateway, you need to connect to your semantic model through this gateway in Power BI Service.

Click this small gear in the upper right corner

vjianpengmsft_5-1708404436410.png

 

vjianpengmsft_4-1708404405099.png

Click New to create a new connection

vjianpengmsft_6-1708404509309.png

Select your gateway in the Gateway Cluster Name, select mysql in Connection Type, and then fill in your MySQL Server, DataBase, Authentication.

vjianpengmsft_8-1708404698499.png

 

3.When you successfully configure the Connection, you can use this gateway connection for your semantic model through the following steps:

vjianpengmsft_9-1708405189726.png

vjianpengmsft_0-1708406001002.png

 

vjianpengmsft_1-1708406084134.png

Through the above steps, you can configure the gateway connection to your semantic model. After successful configuration, you can use the schedule refresh function normally. For more details, please click the related connection below:

Use the on-premises data gateway app | Microsoft Learn

Add or remove a gateway data source - Power BI | Microsoft Learn

Configure scheduled refresh - Power BI | Microsoft Learn

 

 

 

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

I managed to download the Gateway, but when configuring it within the Power BI platform, I encounter an issue. In the authentication field, it only requests one password, but in our company's architecture, there is an SSH port (which has a password) connecting the gateway to AWS, and from AWS to MySQL, there is another connection password. I would need to provide these two passwords, but the Power BI platform only asks for one. Do you know how to solve this issue?

marquesjef_1-1708448308084.png

 

marquesjef_0-1708448175551.png

WhatsApp Image 2024-02-20 at 13.53.05.jpeg

Power BI expects "line of sight"  to the data source. It cannot handle connection open/close  or VPN management or any additional steps.

 

Your gateway needs to reside in AWS as well.

In my case, my server is Linux. Do you know any solution for this situation?

Set up a WS2019 VM in AWS.

Is there a Linux version of the gateway?

No, only Windows. WS2019 preferred

 

lbendlin
Super User
Super User

Check the data source settings in your PBIX. Most likely a rogue data dource that needs a gateway.

 

By the way, your MySQL database very likely needs a gateway anyway.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors