Select All Option While importing columns from the datasource

[Aslan-R]

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.

 

[v-jiascu-msft]

Hi @Aslan-R,

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

[Aslan-R]

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]

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