Upon loading a workbook or doing a schedule refresh on an existing workbook, if you get the following error message, "Invalid connection credentials/details", the issue might occur due to one of the following reasons:
- The license key you have activated using BI Connector does not include server features.
- The number of cores in your server exceeds the number of cores purchased in the BI Connector license key.
To further troubleshoot this issue:
- Log in to your cloud portal.
- Click the 'Settings' icon.
- Navigate to 'Manage Gateways'.
Under your listed / active gateway, the first indication is that the DSN you used to load your workbook must have the alert indicating icon over it.
If you navigate to right side it will an error message for the DSN you have active.
Click on Show Details button to view the message.
If you want to know the exact error message that Power BI Shows, try entering the connection credentials for your DSN and enter your username and password and click Apply button.
The exact error message will be displayed.
The error message shown here will be based on the cores mismatch or your license key features.