Forum Discussion

MainlineData's avatar
MainlineData
Icon for Helper I rankHelper I
2 years ago
Solved

Failed to Test Connection to your Data Source - Retry Credentials - Only On Certain Reports

Hi,   A new issue it seems - I am getting on the below messages on my credentials (for databases) within Power BI Service. This is on a newly uploaded file, which refreshes fine with desktop...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, MainlineData 

    Thank you very much for your reply. This is documented in the official documentation:

    Power Query MySQL database connector - Power Query | Microsoft Learn

    As mentioned earlier, you can connect to MySQL using a standard gateway (Enterprise Gateway) or connect to your MySQL using a cloud link.

    In addition, you can also refer to the following article to connect to your MySQL using dataflow:

    Where to get data - Power Query | 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.

     

SaiTejaTalasila's avatar
SaiTejaTalasila
Icon for Super User rankSuper User
2 years ago

Hi,

 

On power bi service please check whether the personal gateway connection is coming online or not.And you can check with your tenant admin he will help in setting up an on-premises data gateway connection.