Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

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?

miDCH_2-1628745717093.png

 

 

 

1 ACCEPTED SOLUTION
AllisonKennedy
Super User
Super User

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.


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

View solution in original post

4 REPLIES 4
AllisonKennedy
Super User
Super User

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.


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Anonymous
Not applicable

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

Anonymous
Not applicable

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

 

miDCH_0-1628747944351.png

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
Super User
Super User

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


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.