Import new tables of a sql server database in power bi automatically

[javedbh]

I have a sql server database. Some tables are fixed but most of the tables are created at runtime by a desktop application based on the files received. These files contain test results which are saved in these tables. The number and names of the columns of these tables can vary and most likely number/names of columns in one table don’t match those of a different table. The application might create two tables today and create a few more tables a few days later. The information that which table was created for which data is also stored in a mapping table so I can get a list of the tables.

I want to add these tables in power bi automatically. Is this possible? or any other idea how to use them in power bi?

[ImkeF]

You can use parameters in your SQL-queries: http://www.excelguru.ca/blog/2016/04/28/pass-parameters-to-sql-queries/

But one query in the query editor can just return one table. So what you cannot do is to create x different queries/tables at once. If you want to consolidate your multiple tables into one, that's possible. Pls let me know & I will tell you how to achieve this.