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:
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.”
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.
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.
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.
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!
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.
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.
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