Forum Discussion
No Data View Option
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
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).
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!
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.
