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.
I have made a connection by ODBC to an Iseries database, in some tables I get this error when trying to open them: Error: The table has not visible columns and can not be queried. The tables are identical in the Iseries and some I can open them and others I can not. Do you know what I can do? Thank you
Solved! Go to Solution.
hello v-juanli-msft
I have already found the solution, the problem is in the version of the OS of the Iseries with which the files were compiled, recompile the tables to which I did not have access and I can already access them.
Thanks
Hi @jorgeVal
Please check if any difference between those issued tables and other tables.
Verify the data source credential set for the data source in desktop has sufficient permission to access the Iseries database.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hello v-juanli-msft
I have already found the solution, the problem is in the version of the OS of the Iseries with which the files were compiled, recompile the tables to which I did not have access and I can already access them.
Thanks
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.