Connect PowerBi

Support Feature Request
1

Hi, I tried to connect PowerBI with Stardog but no luck.
I did following:
Installed Stardog on Windows
Installed PowerBi on same windows machine
Installed MySQL Drivers as mentioned in the training
Setup properties file with : sql.server.enabled=true
Generated BI mapping for stardog-tutorial-beatles db
Tried to connect from same windows machine using PowerBI.
127.0.0.1:5806 + stardog-tutorial-beatles . User admin password same
127.0.0.1:5820 + stardog-tutorial-beatles . User admin password same

I am getting error "We couldn't authenticate with the credentials provided. Please try again"

I even created a new user and tried but same error. Please help

2

The port should be 5806. Are you getting the same error message for both ports? Can you try another client application such as MySQL Workbench?

3

Yes, I can connect using MySQL Workbench with Port 5806 and user Admin. I could also query the tables there. So what could be the problem with PowerBI?

4

I'm not quite sure what's going on with Power BI. Have you checked the stardog.log for any error messages?

5

Nothing in stardog.log regarding powerbi connection

6

Can you show the screenshot of the MySQL connection dialog in Power BI?

7

Here it is :sa:

image
image1103×655 21.4 KB

8

Hi Jitesh,

In the screenshot, it looks like you're trying to connect to a Stardog database 'music' but the database you created is named 'stardog-tutorial-beatles' looking at your original post. Could you try changing out the database name in PowerBI or confirm the name of your Stardog database?

Cheers,
Noah

9

Ok seems my logs and screenshot are different, but my error is with both databases