exasol / powerbi-exasol

Microsoft Power BI Connector
MIT License
8 stars 4 forks source link

Power BI Desktop February update issue #2

Closed lorenzoincuda closed 6 years ago

lorenzoincuda commented 6 years ago

Hello,

one of the clients of my firm would like to set up a direct-query connection between Microsoft Power BI and Exasol data-base. However, through the latest Power BI version we get the following error:

image

The import connection works correctly but it's not the desired solution.

The previous Power BI version works perfectly (also the direct-query connection), however by this version you cannot edit the report which were already created by the latest version. Here the error: image

Could anyone support me for this issue please?

Thank you in advanced and best regards, Lorenzo

ThomasBestfleisch commented 6 years ago

We try to reproduce it here. Could you additionaly post the exact version number of your Power BI.

ThomasBestfleisch commented 6 years ago

Confirmed, can be easily reproduced:

image

Will let you know once we have a fix.

lorenzoincuda commented 6 years ago

Hi Thomas,

thank you very much!

Best regards, Lorenzo

ThomasBestfleisch commented 6 years ago

Hi Lorenzo,

currently it's quite sure that this is a bug in PowerBI and not the EXASOL connector, because other connectors to other databases are affected as well:

http://community.powerbi.com/t5/Issues/Power-BI-January-release-2-54-is-not-working-when-source-is-used/idi-p/341317/label-name/show%20and%20tell

http://community.powerbi.com/t5/Desktop/We-cannot-convert-the-value-null-to-type-table/td-p/346056

Nevertheless I reported this to Microsoft. Waiting for feedback.

Best

Thomas

lorenzoincuda commented 6 years ago

Hi Thomas,

Thank you for the update and your support!

I will inform my client about that and I'll be waiting for the update from Microsoft.

Best regards, Lorenzo

ThomasBestfleisch commented 6 years ago

Hi Lorenzo,

we could find a workaround to fix this in the Connector.

Best regards

Thomas

lorenzoincuda commented 6 years ago

Hi Thomas,

thank you very much for your support!

Best regards, Lorenzo