Power Query vs SQL Query

[Anonymous]

Hello,

I'm new to PowerBI, so I don't have deep technical knowledge of PowerBI,

In my application, I load data from a huge view. In this view, I have around 40m rows and 100 columns. 

For my app, I need to load only 80 columns, and I need to rename them. I see three solutions:

- change the view (I don't have permission to change DB, so I need to ask another team to modify it for me; other teams can use it)

- load data as is and add two steps - remove and rename. In this case, "view native query" is still active

- create SQL query (one step)

How do you think which solution is better from the performance point of view?

Regards,

Vitalii

[Anonymous]

If it folds, it's just as good as the other team changing the view. In the end, the solution that doesn't require you to wait for another team is the best solution.

--Nate