Forum Discussion

Aslan-R's avatar
Aslan-R
Frequent Visitor
8 years ago

Select All Option While importing columns from the datasource

Hi Team,

 

 

Im connecting to a Calculation View on Hana Database and have enabled "Treat SAP Hana as a relational source" in option sin PowerBi desktop.

 

While browsing the hana objects, I want to select all the columns on a particular view,

 Isn't there way to "Select All" all the dataitems under a cube instead selecting all of them individually. I have got more than 180 columns.

 

 

 

 

3 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi Aslan-R,

     

    Please deselect the option "Treat SAP Hana as a relational source". Then you can select a whole model.

    Select_All_Option_While_importing_columns_from_the_datasource

     

    • Aslan-R's avatar
      Aslan-R
      Frequent Visitor
      8 years ago

      Hi v-jiascu-msft

       

      Thanks for your reply.

      Yes deselecting "Treat SAP Hana as a relational" will enable me to select the whole model.

       

      But what i needed to know is "Is there a way to select all columns/dimensions with above "Treat SAP Hana as a relational" enabled ?

       

      *I did figure out one way to make multiple selections and i.e "Select first column and the press "Shift & page Down"" this selects all the columns visible on ur screen and if u have more number of columns continue to do the same

       

      Regards,

      Aslan

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee
        8 years ago

        Hi Aslan,

         

        That's a fantastic method. Thanks for sharing. I would suggest you create an idea here for the feature selecting all the tables.

         

        Best Regards,

        Dale