Hi Team,
We have a scneario where we need to automate PowerBI dataset creation.In the current situation there are multiple databases with the same tables in different SQL servers. For eg: Table1, Table2 and Table3 will be present in DB1, DB2 and DB3. The structure of the tables will be same. Only difference will be the data present in these tables. Our requirement needs to union these tables - Table1, Table2 and Table3 to create a combined tables and expose it via a power BI dataset. There are N number of tables for which these union needs to be done and published to the same dataset. Is there any way to do this in an automated or config driven manner. Doing these manually will be tedious as there are large number of tables that needs to be exposed like these. .Also please note that these tables needs to exposed in direct query mode. Can some one guide me on a way forward?
