Dynamic Table generation as per data change in SQL

[Anonymous]

Hi ,
Can we execute something like : Select * from table in Power BI .
The reason is I need to see a table having columns as per my data source.

Today Data source (SQL DB) had 5 columns , tomorrow 10 columns , can I automate this without actually performing Drag and Drop as and when Data Source updates ?.

Or any way to generate a simple table based with dynamic columns without actually having any manual intervention.

Regards

[lbendlin]

That is standard functionality in Power Query. If you look at the generated code you won't even see a select statement. 

Alternatively you can use the Advanced options to write a custom query where you can also choose Select *.