ODBC conection returns 'empty table' with an informated table

[Anonymous]

Hi, 

My problem is I´m trying to import a table with an ODBC conetion, the previous view takes the schema of the table, but it reports that the table has no data. I checked it on the other side of the conection, and it has data, is not empty. I have several troubles to import 'big' tables (+100000 registres). Does anyone know somenthing about these kind of situations?

[v-robertq-msft]

Hi,

According to my research, you can refer to these links:

https://community.powerbi.com/t5/Community-Blog/How-to-Connect-to-an-ODBC-Data-Source-From-Power-BI/...

https://docs.microsoft.com/en-us/power-query/connectors/odbc

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-using-generic-interfaces

Best Regards,

Community Support Team _Robert Qin

[Anonymous]

Hi, 

I tried to refresh the preview of the table, but it takes too long and finally fails with the error 'container exit with code 0xFFFFFFFF'. It could be a problem with de conection from the Power BI side? Or, instead, it cuold be a problem of the conection from the other side? I read many posts about that error message and it can be caused because of many reasons. Do you know somenhing about the possible causes of this error?

Thank you.

Best Regards,

Jon

[v-robertq-msft]

Hi,

Please refer to link and check if it can be helpful:

https://answers.microsoft.com/en-us/msoffice/forum/all/container-exited-unexpectedly-with-code-0xfff...

Best Regards,

Community Support Team _Robert Qin