Forum Discussion

darroyo's avatar
darroyo
Frequent Visitor
7 years ago

Fill 1 table with 1 MySQL query executing on multiple (equal) databases

Hello. I have a database for each of our customers. Every database has the same tables and fields. I wan to fill a Power BI table with some common data of all these databases with a MySQL query.   ...
Need Help
darroyo's avatar
darroyo
Frequent Visitor
7 years ago

Thanks Yuliana, but I think that solution is not good for me.

OK I can make a great query with copy/paste of my query connecting each database using prefix before tables, but keep in mind I would have abot 50 copies of the main query. The great query would be so large but that is not the problem. The problem would be the time expended in managing that query when some change is needed.

 

I keep your idea as the last chance, but I hope there's another method.

 

Best regards.

David.

darroyo's avatar
darroyo
Frequent Visitor
6 years ago

Hi, I just want to reactivate this question. I have no solution by now, but I think it should be a way to do this with PowerBI.

 

For example, when I work with Qlik Sense I can make a first query in order to get a list of all database names, and then I can write a loop sentence executing my queries in every database of the list.

 

Thanks for your attention!