Modify Refresh SQL

[Anonymous]

Hi All,

I need to modify the import statement from getData. I want to cut down the size of the data by eliminating some columns that will not be used. Since the source was Azure SQL Server (using import) there must be SQL somewhere I can modify. Is that possible?

Thanks!

[mwegener · Accepted solution]

Hi @Anonymous,

If you use Power Query (M-Code), the query folding generates the SQL statement.

Just add a "Choose Columns" step.

Take a look at this.

https://www.mssqltips.com/sqlservertip/4563/power-bi-native-query-and-query-folding/

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[az38]

Hi @Anonymous 

there are two option:

1. Power Query editor. pick your data source and change Source step at the right pane

2. Home ribbon - Edit queries - Data Source Settings (but in most of cases you will be still needed to go to the power query editor and edit data source if you wat to delete columns)

do not hesitate to give a kudo to useful posts and mark solutions as solution