I am again in the process of improving my data model and this time it is the import from a SQL server. I am currently loading the entire table from the server into PowerBi, and I only need two columns from the table. Is there a possibility, instead of using select *, to go to the two columns directly?
And 2nd question, could the list be restricted to certain import parameters? for example on the date?