Forum Discussion
Need help to resolve column contains table structure
have connected to Power BI with ODBC connection containig datastructure having all columns like
"ID", "Name", "License" and values as "1", "ABC", "[8,60]" When I try to transform "License" column which shows me as "table" and when try to expand it there not able to see columns
and when click on table it gives me error as "Expression error: The column 'id' of the table wasn't found.
Note: When I connect to Power BI with direct Azure Cosmos db then this "License" column appear as list and able to expand it, But requirement is ODBC connection.
Please help to resolve this. Thanks in advance.
Hello Community,
I found the solution for this, though it is not inside power BI but in the ODBC driver itserl.
Here in the document user can find how to create schema and attach that schema in ODBC driver itself and while connecting to this driver with Power BI one can see the table structure for the column and able to load it.
1 Reply
Hello Community,
I found the solution for this, though it is not inside power BI but in the ODBC driver itserl.
Here in the document user can find how to create schema and attach that schema in ODBC driver itself and while connecting to this driver with Power BI one can see the table structure for the column and able to load it.