Forum Discussion

udayadeven's avatar
udayadeven
Frequent Visitor
3 years ago

Show data table option in PowerBI Desktop

Hi Experts ,

 

I'm very new to powerBI ,

 

I'm using a sharepoint list to generate some visuals .. 

 

First i directly call the PowerBI  through the sharepoint list   using below option 

 

 

once you directed to the powerBI ,it allow me to create a table using the list data thro below option 

 

 

my concern is if i connect the List through PowerBI desktop , it doesn't have an option like above "Show data table" .. Would you pls help me to create a table in PowerBI visual as the same behaviours in "Show data table " online .

 

rgds

AD

4 Replies

  • Hi udayadeven,

     

    What Show as table does is essentially insert a table visual in Power BI Desktop with all the fields from the list. There is no Show as table in the desktop so you have to adjust the size of some or all of the existing visuals and insert the table accordingly.

     

     

    • udayadeven's avatar
      udayadeven
      Frequent Visitor

      Hi Danextian ,

       

      Thanks for the quick response ..  Insert table will show all  records of the selected fields in the List .. But what i need as behave in online PowerBI , it should show only the records which are selected on above visulas .. lets say for a particular date .

       

      rgds

      AD

      • danextian's avatar
        danextian
        Super User

        I'm confused. You said you wanted to do in the desktop how Show as table behaves in the web which is as I stated in my previous reply. If you want to filter it by date, you need to add a date slicer somewhere in the report or add it to the filter pane.