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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
hboenw
Frequent Visitor

NO fields avaiable in Report tab when using sql statement

Hi,

I have used a sql statement with Oracle as server.  In the model tab I see Query1 with the columns. When I edit the query I see in power qyuery all the columns and corresponding data.

I only see 2 tabs i.e. the model and the report tabs (missing the data tab). But when I click on the report tab I dont see the columns in the Fields tab despite that i can see the columns in the query1 table. Any idea how to solve this?

hboenw_0-1672694109205.png

Model tab

hboenw_1-1672694278390.png

 

Powerquery

hboenw_2-1672694301531.png

 

Report tab

hboenw_3-1672694389584.png

 

 

 

 

 

 

2 ACCEPTED SOLUTIONS
MahyarTF
Memorable Member
Memorable Member

Hi,

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

MahyarTF_0-1672700988318.png

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 :

MahyarTF_1-1672701068574.png

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

Mahyartf

View solution in original post

v-xinruzhu-msft
Community Support
Community Support

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

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.

View solution in original post

3 REPLIES 3
hboenw
Frequent Visitor

yes, I found the solution also. Its because I used direct query instead of import.

Thanks

v-xinruzhu-msft
Community Support
Community Support

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

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.

MahyarTF
Memorable Member
Memorable Member

Hi,

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

MahyarTF_0-1672700988318.png

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 :

MahyarTF_1-1672701068574.png

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

Mahyartf

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors