Change table from mysql data base

[OscarSuarez10]

Hello I am using MySql to get the data to use in my power bi project.

I want to use the same Report for all the tables that I have in my data base:

How can I change the table from the data base from the report section? : I know I can do it from the advanced editor of the query editor but I don´t want to do that in this way.

[kentyler · Accepted solution]

I don't think you can do it that way.

If the tables all have identical column names why don't you combine them and add a flag field for 1,2,3,4,5

then you have just one data table for your report and you create a slicer that shows you the records for 1,2,3,4 or 5