Power BI Connector

3rd-Party Integrations
21

Hello @jprice,

Thank you for your anwer and feedback. Compare to other vendors it’s even impressive. I will test it more in details next week. I have just installed the package and I can confirm that the issue is resolved.

Regards
Emmanuel

1 Like
22

hi @jprice, I tried to use the latest Power BI desktop version and also downloaded the connector - SingleStoreDB Cloud · SingleStore Documentation

However, when i start PowerBI, i am getting the following error
image

1 Like
23

Hi @sdevaiah,

Thanks for your post. We are working on getting the connector deployed in Power BI natively through the Certified Connector program. For now, you need to change the Data Extensions setting in Power BI to allow extensions to load without warning as shown in the screenshot attached.

image

1 Like
24

Thanks @jprice, That worked for now. Please do let us know Once this is certified.

1 Like
25

That’s great news! I will update this thread once it is certified.

1 Like
26

I am able to connect to Singlestore in DirecQuery mode using Power BI Desktop. But when the same report is publised to PBI Service, errors out “Couldn’t load the model schema associated with this report. Make sure you have a connection to the server, and try again”

The Ent gateway connection is online and the data sources are online as well.

Wonder if DirectQuery to Singlestore from PBI Service is even supported. Documentation says its not supported for personal gateways.

1 Like
27

Hi narendra! :wave: Thanks for joining our community!
I’m sorry you are having this difficulty. I’ll get a team member to double check and see if there is any work around we can suggest.
We appreciate your patience.
In the meantime, what version are you running?

1 Like
28

Hi @narendra_reddy,
Can you please try to pull the latest version of the Power BI connector from our documentation? Please follow closely the instructions for upgrading the connector and make sure to upgrade the connector on all of the Deskop and Gateway machines.
Please let us know if this resolves your issues!
Cheers,
Julie

2 Likes
31

Hi @ahmedelnahrawy,

Welcome to the SingleStore community! Can you please provide some more information? Are you using Power BI Service or Desktop? What version? What authentication mode are you using in Power BI?

Cheers,
Julie

2 Likes
32

Thank you for your reply @jprice everything is solved.

2 Likes
33

That’s great news! Thanks for responding.

2 Likes
35

Hi
I also have issue connecting with the PowerBI Desktop: Version: 2.126.1261.0 32-bit (February 2024)
and SingleStoreDB: 8.1.32 (memsql_version)
with the latest connector I downloaded from your Git: singlestore-connector-odbc-1.1.5-win64.msi
on my PC: Windows 10

the following error:
Details: “The ‘Driver’ property with value ‘{SingleStore ODBC Unicode Driver}’ doesn’t correspond to an installed ODBC driver.”