Read multiple SQL server tables with LIKE operator

[chetanbi]

Hi...

I have a requirement to select all the tables which have name "Sales_" in my SQL server database.

Is there a way to read all of them using LIKE operator in power query.

Thanks in advance for your help

[AlexisOlson]

What do you mean by "select all the tables"?

If you mean automatically load each match to a separate query, then I don't think this is possible natively in Power BI (but you can probably do it programmatically with an external tool).

If you want to load all the matches into a single query by unioning/appending them together, then this should be possible in the Query Editor.