I've tried asking this question on a specific Power BI forum but no good:
So I'm wondering if this can be achieved by me having 1 x SQL server that merges all the data from the tables in the cloud MySQL server. Thus Power BI only queries 1 x table?
- I have Power BI reporting on a phone system.
- Data is a MySQL database which my Power BI connects to.
- The PBX platform is from a company called "yeastar"
However, the issue is each month this phone system creates a new table. I can't control or change this.
My Power BI connects to 1 month table and all works fine, however I can't then retrieve data for another month because it's in another table. Every month a new table is created I have to make a new Power BI project and connect to that new table.
Can I get the table name as a wildcard follewed by the fields?
Do I need another SQL server to use as a "transition" so it queries all these table then presents 1 large table to Power BI?
Example Tables / Queries
Screen shot shows the database I'm querying.