We have an internal beta now of a new, fully-rewritten Power BI connector for SingleStore, and we are working with Microsoft to request that they include this with Power BI as a built-in, native connector.
If you would like a built-in SingleStore connector in Power BI, please vote for it here:
https://ideas.powerbi.com/ideas/idea/?ideaid=effcc58b-0d72-eb11-8fed-501ac50aa35e
and encourage your co-workers to do the same!
Have been downgrading Power BI trying to use this Connector but still to no avail.
Current release does not recongnize it,
Gone from latest 2.8x to 2.74 and still getting:
Details: “The ‘Driver’ property with value ‘{SingleStore ODBC 0.8.1-beta Unicode Driver}’ doesn’t correspond to an installed ODBC driver.”
What is wrong ?
When can we get a proper supported certified connected to allow direct queries ?
Thank you,
Hi @KillerDAN,
Can you please confirm if you followed the steps found here to get the latest Power BI installer? You should not have to downgrade Power BI to get things working.
Cheers,
Julie
Yes I did but your questions is ambiguous.
Latest Power BI installer does not conform with pre requisite certification matrix.
I used the latest from the following link and tried walking backwards in versions.
Regardless the version does not seem to be the issue but this one does;
Details: “The ‘Driver’ property with value ‘{SingleStore ODBC 0.8.1-beta Unicode Driver}’ doesn’t correspond to an installed ODBC driver.”
Thanks for clarifying how you installed the connector. We are looking into this issue and will report back to you as soon as possible.
Also, welcome to SingleStore forum!
Hello @KillerDAN,
Can you please try to download the connector bundle file again from our documentation site? We have fixed the dependency issue with the ODBC driver. If you continue to have issues, it might be related to another SingleStore ODBC version being installed on your client machine.
Best,
Julie
Hi,
I’m start working SingleStore DB and now I would like to take benefit of this database with PowerBI. I have installed the version 2.96.701.0 of PowerBi.
With the current package 1.0.1 for a direct connection I have the following error.
Details: "ODBC: ERROR [HY000] [ss-1.0.1]Unknown system variable 'memsql_version’
ERROR [HY000] [ss-1.0.1]Unknown system variable ‘memsql_version’"
I have tried to put the tcp port in the hostname and I got the following error.
Microsoft.Mashup.Client.UI.Shared.ExceptionResultException
Microsoft.Mashup.Evaluator.Interface.ErrorException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. —> System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. —> System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
I’m running powerbi from Windows 2016 Server standard.
If someone can help
Regards
Emmanuel
Hi @e.soden, can you confirm the version of SingleStore that you are using? We found and fixed a bug with the driver and SingleStore 7.5 and are working on updating the Power BI bundle. I will report back as soon as it’s been updated.
Best,
Julie
Hi Julie,
I’m using SingleStore 7.5.7.
Regards
Emmanuel
Hello, @e.soden, the bundle has been updated, so please uninstall your existing connector and ODBC driver and pull the latest from our documentation found here. Thanks for your patience!
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
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
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.
That’s great news! I will update this thread once it is certified.
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.
Hi narendra! 
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?
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
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