Connecting Remote server(Cache) to Power BI

Question

Question

Vikram Annadurai · Dec 18, 2019

Hi Folks,

I would like to visulaize the tables and data on Power BI, so I try to connect the romote server to Power BI to access the tables and data of remote server. I can able to connect that remote server to our Studio also able to view class files.
But I couldn't able to connect the remote server to power BI. I'm getting the below error while click on the tables

"Expression.Error: This native database query isn't currently supported"

So now I'm in need of help

Thanks,

Vikram

Discussion (8)1

Log in or sign up to continue

Alexander Koblov · Dec 18, 2019

Hi Vikram.

Looks like you trying to use InterSystems IRIS Power BI Adaptor to connect to Caché. This adaptor does not support Caché.

Use ODBC connection to connect to Caché from Power BI.

Hope this helps,
Alexander.

1 0

score 0 · Answer 1 · 2019-12-18T05:07:03-05:00

Vikram Annadurai · Dec 18, 2019

WOW!!!

Its working..

Thanks Alex, thanks for your help.

0 0

score 0 · Answer 2 · 2019-12-19T10:01:42-05:00

Oops!!!,

I connected the Cache from Power BI using ODBC connection. And I can able to view the tables but I could't able to view the data records. getting some error when I shoot on the table name. I could't trace what I'm missing. Please help me

Error Message: "Value cannot be null. Parameter name: exceptionType"

Thanks,

Vikram

score 0 · Answer 3 · 2019-12-20T04:30:27-05:00

I also see this error for some tables. I don't know what's causing this.

I've googled it and looks like some error with ODBC Connections from Power BI.

score 0 · Answer 4 · 2019-12-20T06:25:36-05:00

Vikram Annadurai · Dec 20, 2019

Okay, Thanks Alex.

If any other possible to view that table records , please let me know.

Thanks,

Vikram

0 0

score 0 · Answer 5 · 2023-10-20T21:48:14-04:00

Sabrina Paravidini · Oct 20, 2023

Please, how did you manage to solve @Alexander Koblov ?

0 0

score 0 · Answer 6 · 2023-10-21T07:16:09-04:00

Alexander Koblov · Oct 21, 2023

I did not.

0 0

score 0 · Answer 7 · 2024-10-20T00:58:43-04:00

Ruan Medeiros · Oct 20

Qual seria a URL de conexão ODBC que você usou?

0 0