Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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....
Solved! Go to 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!
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.