Forum Discussion
Error getting data via ODBC Driver
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....
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!
3 Replies
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?
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!No problem, glad you got it resolved!
