Forum Discussion

kagu's avatar
kagu
Frequent Visitor
3 years ago
Solved

Import PowerQuery from Excel: Field/Tables not visible

Hello,

 

I want to import PowerQuery from my excel-data and the import does not work. I can see the data in the Power Query-Editor, but when I chang into the frontend there is no data visible. Is there soembody who know the problem and the solution for it?

 

Thank, Katharina

 

 

 

  • it seems tables were disabled. check once and enable the query load at power query editor side.

    just goto power query editor side and right click on the table and click on "Enable load".

    if you see the pic, table names with slant letters are disabled, it means they were not upload in power bi desktop, only sits in power query side, so you can enable it.

    please accept it as solution if you got the answer from this.

2 Replies

  • it seems tables were disabled. check once and enable the query load at power query editor side.

    just goto power query editor side and right click on the table and click on "Enable load".

    if you see the pic, table names with slant letters are disabled, it means they were not upload in power bi desktop, only sits in power query side, so you can enable it.

    please accept it as solution if you got the answer from this.

  • kagu's avatar
    kagu
    Frequent Visitor

    Thanks a lot, that helps 🙂