cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Add Multiple MS SQL data source with same queries

Hi Everyone, 

 

I am new here, hopefully I have posted this question to a correct topic 🙂

 

I have lot of MSSQL Server on client side with the same database and data structure, and I would like to make Query for all of them and union them in Power BI Desktop, but to do the same data source creation steps and data transformation steps more then 100 times sounds not so efficient. At the end the union is only one step 🙂

 

I have tried to use Power Query for this, but I am out of ideas.

Are there any solution to automatize the Query creation for all datasources like with PowerShell API or something like that?

I would like to fetch the data in Direct Query way.

 

Thank You for your help, 

BR, 

Sipi

1 ACCEPTED SOLUTION
Super User III
Super User III

Direct Query?  What's your reason for not doing this in a SQL Server View then?

View solution in original post

1 REPLY 1
Super User III
Super User III

Direct Query?  What's your reason for not doing this in a SQL Server View then?

View solution in original post

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors