Power BI Connector

3rd-Party Integrations
1

The Direct query is not working when I use this connector:

I’m getting OLE DB or ODBC error: [Expression.Error] The value provided for SQL capability ‘FractionalSecondsScale’ in Odbc.DataSource is invalid
error.

Is there something I’m missing?

2 Likes
2

Hi!

What version of PowerBI Desktop are you running and on what operation are you getting this error, any DirectQuery report?

Thanks,

Shannon

1 Like
3

Hi! Thanks in advance!
I’m using this power bi and the problem is at DirectQuery report. The preview and the Import works perfectly but I’m unable to use it at DirectQuery.
ODBC Mysql Driver is already installed (And it’s the only one)

Version : 2.80.5803.1061 64- bit (April 2020)

1 Like
4

Hi
We have identified an issue with our connector starting PBI Desktop 2.76 and our engineering team is working on a fix for the connector. Do you have access to PBI desktop version 2.75 and would you be able to try it? I will let you know when the connector patch is available.

4 Likes
5

Thanks, I really appreciate your help. I download the PBI 2.75 version and it worked fine. Once the connector is available please let me know so we can upgrade the version. Thanks a lot for the quick response!

1 Like
6

Hi,
is there an Update already to this topic? I would be interested as well. Running Power BI in Version: 2.80.5803.1061 64-bit (April 2020)

Thank you

1 Like
7

Hi Christian,

I cannot share a specific update, but we are actively working to provide resolution to this issue.

Thanks,
Shannon

1 Like
8

Is there some update about the connector?

1 Like
9

Hello @moralez.rodrigo , Do you still have the Power BI 2.75 installer with you? I have been looking everywhere to see if I can download it.

I am having the same problem with the MemSQL Direct Connector.

If you could kindly share your PBI 2.75 Installer, would be great.

Thank you.

1 Like
10

Hello Fernando,

Here is a personal website from a Sergio, a full-time Microsoft employee, who has made available previous versions of PowerBI Desktop.

This link references PBI 2.75 Installers, and he has documented other versions on a monthly basis in 2019:

There does not seem to be previous versions in 2020 uploaded at this time.

Thanks in advance!
David Yakobovitch
SingleStore Education

1 Like
11

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!

4 Likes
12

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,

1 Like
13

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

1 Like
14

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

1 Like
15

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!

1 Like
16

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

1 Like
17

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

1 Like
18

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

1 Like
19

Hi Julie,

I’m using SingleStore 7.5.7.

Regards
Emmanuel

1 Like
20

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!

2 Likes