Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Say you have a sql server with several databases within, one database for each customer/client. These databases have the same tables, same structure etc. How would go about developing a report which extracts the same query from every databases and uses the data as one data source, knowing the number of databases might change periodically, new customers/customers leaving ?
I know this a large question, let me see if I can break it up:
I hope my questions are clear and consice, any help would be appreciated.
Thank you.
First, I would wonder why you have a single database for each customer instead of one database with a field for customer to differentiate between them.
But...you should be able to access them individually using Power Query by using each database as a data source. Add a field for customer to each table pulled from each database so that when you merge each query together you can still tell which customer the data applies to. I don't believe that you can loop through them in Power Query, but someone who is stronger in that can offer guidance.
But again, your underlying is that you shouldn't be using separate databases for each customer...that is just creating problems for yourself.
@ImkeF , can you help on this
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |