Connecting to BI server with PowerBI: common issues

Created by Steve Place, Modified on Wed, 08 May 2024 at 04:26 PM by Steve Place

Our BI Tools and SQL Queries documentation is a good companion to this article.

  1. Using the wrong driver version. 
    1. Per our documentation (link above), make sure you have the MySQL Connector/NET driver, version 8.0.22 or earlier.
  2. Using the wrong credentials.
    1. Use the credentials for a Stardog user (that you can see in the Security tab of Studio), not the credentials you use to log into Stardog Cloud or Launchpad.
  3. Including "http://" in your connection string.
    1. Just use "example-company-bi-server.stardog.cloud:5806", rather than "http://example-company-bi-server.stardog.cloud:5806".
  4. Using Windows auth.
    1. Use Database instead.


As a final note, PowerBI caches connection settings. If you changed your settings and still aren't able to connect, try clearing your connection settings in Home > Queries > Transform Data > Data source settings. Then try connecting again with your new settings. (Note: try merely editing your settings first. This is a "turn it off and back on again" solution.)

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article