NO fields avaiable in Report tab when using sql statement

Hi,

As you use the direct Query Mode in Transforming data, the Data Panel isnot shown,

In my opinion if you want to see the data in your Power BI App, you need to use the Import/Dual mode in your model or when your data is loaded :

Appreciate your Kudos and please mark it as a solution if it help you.

Hi hboenw 

Did you import the data by "Direct Query" connection, if you use this connection, you cannot see the detail data of the table, you can refer to the following link:

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about#directquery-connections

You can use "Import" connection to import data

Dataset modes in the Power BI service - Power BI | Microsoft Learn

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.