Import PowerQuery from Excel: Field/Tables not visible

[kagu]

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

[kagu]

Thanks a lot, that helps 🙂

[sudhav · Accepted solution]

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.