Forum Discussion
Error loading table data "Compex types"
Hi All, I succesfully connected powerBI via "On Premis Gateway" to our SQL server. In the next window I can see all tables in the database. This is perfect. However when selecting tables, s...
Hi there
What happens if you had to write a custom TSQL Query instead of just selecting the tables?
This would then allow you to be able to limit the columns until you find the ones that are causing the issue?
What happens if you had to write a custom TSQL Query instead of just selecting the tables?
This would then allow you to be able to limit the columns until you find the ones that are causing the issue?
Hi GilbertQ,
Thank you for your help.
I have tried loading a single column like "Id" with sql power query editor and it still shows as empty (power bi desktop). I repeated this action for every column in the table but with the same result. Hower when I read the table with sql management studio it shows 75 rows, all columns are filled with data...
Br,
Nicolas
- Hi there
What if you had to start a new PBIX and see if you can get the actual data?tried it multiple times... same result... :-(
thx for your help.
Br,
Nicolas