Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Couldn't see Fields

Hi All

 

I am new of Power BI and trying to work on the report. But after I click the Query Editor, the table fields are no more display. 

And I tried "close and apply" there is no change. 

 

How I get back to the normal and do the report?

 

 

 

  • It looks like you have deleted some steps. Do you have an older version of the file you can copy the Advanced Editor code from and paste into this file? I don't know what you clicked, so not sure how much you have lost or what steps are missing, and don't know how the API data is formatted to help much unfortunately.

4 Replies

  • AllisonKennedy's avatar
    AllisonKennedy
    Icon for Community Champion rankCommunity Champion

    Anonymous You don't have any fields in your Query, so will need to add more steps to develop this further. It looks like you're using a website as a data source??? What is the data source? api? Excel? html table? You will need to extract the tables and fields from the webpage, right now you only have the entire webpage and Power BI doesn't know how to get fields yet.

     

    We need a bit more detail about your data source to guide you in the right direction from here.

  • Anonymous's avatar
    Anonymous
    Not applicable

    AllisonKennedy Hi Allison, I am using API to connecting the data. 

     

    It was find from the beginning but after I click something the Fields are gone and every time open the Power Query Editor to me. 

  • AllisonKennedy's avatar
    AllisonKennedy
    Icon for Community Champion rankCommunity Champion

    It looks like you have deleted some steps. Do you have an older version of the file you can copy the Advanced Editor code from and paste into this file? I don't know what you clicked, so not sure how much you have lost or what steps are missing, and don't know how the API data is formatted to help much unfortunately.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Even I open a new Power Bi and "Get data" from web (API), it also display the same result to me.