Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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, 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.  

Dataflow
Need Help
Tutorial Requests

6 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    7 years ago
    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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's avatar
        GilbertQ
        Super User
        7 years ago
        Hi there

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