can I run a query on a MSSQL folder via PowerBI?

[DeBIe]

Hi,

I would like to know if I can avoid the process of appending multiple (equal) queries within PowerBI. I can do this within MSSQL via the following method:

In MSSQL we have a folder structure. For example all our Front-End databases within the folder "Frontend". In this folder we have 10 instances. One for each customer. I am able to run a query on the folder which gives me the result from all customers. Example query:
USE DATABASENAME
SELECT * FROM TABLE

Is it somehow possible to run this query via PowerBI on this "Folder"?

[Greg_Deckler]

@DeBIe Do you get the Advanced option when connecting to MySQL database like with SQL Server?

[DeBIe]

Hey @Greg_Deckler ,

Yes, but this doesn't allow me to run a query on a folder in MSSQL?

[Greg_Deckler]

@DeBIe Probably have to write 10 queries (1 for each instance) and then do an Append query in Power Query Editor and mark the 10 queries as "Do not load" then.

[DeBIe]

@Greg_Deckler in my original first post you can see that that is the process which I am trying to avoid. I started this topic to check if theres an alternative.

[Greg_Deckler]

@DeBIe Pretty sure you can't avoid it. Connecting MySQL to Power BI: A Comprehensive Guide (hevodata.com)

[DeBIe]

Ok that's unfortunate. Thanks for letting me know.

If somebody reads this and has been able to manage this then please let me know 🙂