Issue of Invalid Data Credentials

Hi , azure12 

According to my troubleshooting experience, generally if Power BI gives an "Invalid credential" error, in addition to the fact that the credential you provided to Power BI to connect to the data source is indeed invalid, there is another possibility that the connection is from Power BI The network traffic of the data source is blocked by the firewall or rules at the data source end. This is because the Power BI desktop has always used a fixed IP address to connect to the data source, but the IP address used by the Power BI service to connect to the data source is random. It is fixed and will be updated regularly. One solution to this potential problem is that you can try to install the on-premise data gateway on the computer where Power BI desktop is successfully connected to the data source, as a bridge to help Power BI service connect to the data source. Because the IP address of the connection data source used by the on-premise data gateway is also fixed. You can refer to these two official documents:

Install an on-premises data gateway | Microsoft Learn

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

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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