Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
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.
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
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.
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
Even I open a new Power Bi and "Get data" from web (API), it also display the same result to me.
@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.
@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.
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