Error loading table data "Compex types"

[Anonymous]

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, some show its data and others load nothing. Going further PowerBI tells me "Some complex types cannot be loaded. Would you like to remove the columns in query "...." that contain these types." When selecting "Yes" some columns are deleted but the table is still empty... 

When I try the same in powerBI desktop it behaves the same. Rather it doesnt even tell me there is something wrong... just empty tables...

Plz help!

BR,

Nicolas

I need to see all transactions of status different then 10.  

[ilyass777]

@Everyone , make sure that the table is not loaded. 

[GilbertQ]

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?

[Anonymous]

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

[GilbertQ]

Hi there

What if you had to start a new PBIX and see if you can get the actual data?

[Anonymous]

tried it multiple times... same result... 😞

thx for your help.

Br,

Nicolas

[GilbertQ]

That is really interesting, I have never encountered that before.