Forum Discussion

ErinMark's avatar
ErinMark
New Member
10 years ago
Solved

No Data View Option

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 goi...
  • HarrisMalik's avatar
    HarrisMalik
    10 years ago

    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

Peter1's avatar
Peter1
New Member
8 years ago

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