Error getting data via ODBC Driver

[brunozanoelo]

My power bi cant update data to my dataset, how can i do!? What is this error?

Cluster URI:	WABI-BRAZIL-SOUTH-redirect.analysis.windows.net
ID da atividade:	eeff62aa-e11f-43d7-b364-b0bf65aabcb4
Solicitar ID:	f360fd85-a3bb-4a78-a09f-e41271b1d2af
Hora:	2016-12-12 05:03:07Z

Thanks Guys! Wainting for a reply....

[Greg_Deckler]

Can you provide some context? Is this error in the Service or the Desktop? What is the ODBC source type that you are trying to access? Oracle? MySQL? Teradata? If this is the Service, is the ODBC source on-premises or in the cloud? If it is on-premises, do you have a gateway installed?

[brunozanoelo · Accepted solution]

Hi @Greg_Deckler!

I think i found the problem in my SQL, one wrong left join...

Was traversing 12 records for each "select from" record, returning more than 39 million records to read, and therefore, causing a very long consultation. I believe the error was related to the processing time to obtain the data.

1) My DB is Firebird 2.5.4.
2) The ODBC is x64 bits for Windows, you can download here.

3) The Source is on-premises.

Will move to closed. Thank you anyway for your attention!

[Greg_Deckler]

No problem, glad you got it resolved!