Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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?
Model tab
Powerquery
Report tab
Solved! Go to Solution.
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:
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.
yes, I found the solution also. Its because I used direct query instead of import.
Thanks
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:
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.
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
65 | |
63 | |
52 | |
37 | |
36 |
User | Count |
---|---|
82 | |
66 | |
61 | |
46 | |
45 |