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, s...
Dataflow
Need Help
Tutorial Requests
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?
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    tried it multiple times... same result... :-(

     

    thx for your help.

     

    Br,

     

    Nicolas

    • GilbertQ's avatar
      GilbertQ
      Super User
      7 years ago
      That is really interesting, I have never encountered that before.