July 20, 2026 at 5:04 pm
I don't see a PowerBI forum, so I'm posting here.
I have a need to create a report using one query but multiple SQL Servers. I'm wondering if I could create a CMS registered group and somehow pass the query to all servers in the group at the same time and pull back the results to a report.
Is that possible? Or are data sources essentially hardcoded into the data sources?
July 20, 2026 at 7:36 pm
If you can create a stored procedure that returns the data that you need, then you can use that as the source of your report/table in your model.
Just in case you've never played with PowerBI very much... Go to Get Data, SQL Server, and click on the >.
Then you can specify a stored procedure or a query that you want PowerBI to pass to SQL Server and return the results. So you could do something like
EXEC dbo.MyStoredProcedure @Param1=12, @Param2='Frank';
and PowerBi would just get the data back from it. So if you had all the servers dump their data to a single table or result set / stored procedure, all that would be available to PowerBI.
July 20, 2026 at 8:17 pm
I appreciate the answer, but I'm not sure that answers my question. Thank you, though.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply