No Data View Option

[ErinMark]

Hi there,

Brand new to Power BI. Excel power user and capable enough in SQL. Got going yesterday linking queried SQL tables in Desktop Power BI, but I can no longer view the Data view. What's going on? If I open a blank Power BI instance, I see all three options on the left - relationships, report, but no data view. What am I missing?

Thanks fopr your time! Erin

[KaleemMI]

When Data Connectivity Mode is DirectQuery; you will not have Data View. It is not a bug, it is designed that way.

For the same model, if you Import any table or create New table from Table Tools then Data View is visible. If you select newly Imported Table or newly created Table, it will show the data; However when you select DirectQuery Table it will give the message "This table uses DirectQuery and cannot be shown"

[binbeans]

I have same problem but it fixed. The data is there only the blank row goes top. You guys need to remove blank row since all the data at the bottom row after blank rows. Hope this can help you guys.

[rsarapalli]

I faced the same issue and resolved it by selecting "Import" instead of "Direct Query" under data connectivity mode options.

Thanks

[Peter1]

This solution did not work for me. I have another Power BI report where I have no problem, I can see the data view icon (that one has two tables, and a third that I created from those two).

The data view option is available to me when I open a new file, but when I open another file it is not there...

The other file has 8 tables, and never had the data view icon available. I am not sure what I did differently (nothing, as far as I can tell, except for the number of tables). The previous solution in this thread (clicking on the Query Editor) did not solve the issue. I can get to the query editor but it doesnt allow me to add tables or format the numbers in a column.

On the Modelling Tab the "New Table" button is greyed out, as is the Formatting panel on the same tab.

I am not sure if there is some limitation on the number of tables, how the data is brought in (DirectQuery or not) etc. but I can't figure it ourt and any help would be appreciated.

I am on version Version 2.54.4970.961 64-bit (January, 2018), and I am a new user for Power BI and not very technical (so be gentle with me).

[Biss]

I think this is because you've set your query up as a Direct Query, rather than selecting Import, when setting up your query.  I was having the same problem this morning, so I set up a brand new query both ways (ie one as an Import, and one as a Direct Query).  As soon as you set it up as Direct Query the Data View option disappears. 

No idea why though - I'm very new to Power BI too!

[carlosDash]

I believe @Biss is correct. 

I tried connecting to a local SQL Express Server with Direct Query and it would not produce a "Data" view. Data is available in the "Edit Query" window. The developers should add a "greyed out" Data view button which shows a tooltip on hover explaining why there is no view.

[dosansil]

How to fix this issue; I also have the same problem.

[estelter]

Hi, go up to the Home Tab and hit edit data

[HongShi]

hi there,

are there solution, please share. I have the same issue  No Data View. 

Thank you

[Diego-mx]

Guys. Hey Guys!!  The solution is marked incorrect.  
I lost an hour of myday understanding the issue, and it turned out to have been known all along.
It's just not pointed to as a solution.   
The problem is the import method as DirectQuery instead of Import.  
Can someone mark the correct answer?  

[joshlwulf]

This is actually not a solution. That's just explaining when the Data view is not available. In many circumstances, Import is not a viable solution. That's why there is an option for Direct Query. The solution actually appears to be that if you are in Direct Query and can not move to Import, then you need to use the Edit Query option to view the data structure.

[msupawadee]

Hi All;

How to fix this issue; I also have the same problem.

Best Regard

Supawadee

[estelter]

Hi, go up to the Home Tab and hit edit data

[aj81]

When you load data to the report use "Import" rather than "DirectQuery".

[anguyen83]

Hi

I am having the same problem as well. On the left hand side I can see the report view and relationship view. there is no data view. Also I went into edit queries however when i close it I cannot see the data view on the lef thand pane

can someone help?

[aj81]

When loading data to a report use "Import" rather than "DirectQuery".

[HarrisMalik · Accepted solution]

@ErinMark when you are on reort tab do you see the Edit Queries in the top ribbon. What happens if you click it.

Please share screenshot for some better understanding.

Regards

Harris

[ErinMark]

Doh! That fixed it. So obvious...

[DMogadati]

How did you fix it? I still have same problem. I can see it in Edit Query mode but not in power bi desktop. Please help

[dosansil]

How did you fix it? I still have same problem. I can see it in Edit Query mode but not in power bi desktop. Please help [2]