cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gyorgy89benix
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
lbendlin
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
lbendlin
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
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

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.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.