Forum Discussion

brunozanoelo's avatar
brunozanoelo
Post Patron
9 years ago
Solved

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-b0bf65...
General Comment
Need Help
Show and Tell
  • brunozanoelo's avatar
    brunozanoelo
    9 years ago

    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!

brunozanoelo's avatar
brunozanoelo
Post Patron
9 years ago

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's avatar
Greg_Deckler
Community Champion
9 years ago

No problem, glad you got it resolved!