Forum Discussion

OscarSuarez10's avatar
OscarSuarez10
Icon for Helper III rankHelper III
6 years ago
Solved

Change table from mysql data base

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.

  • 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

1 Reply

  • kentyler's avatar
    kentyler
    Icon for Solution Sage rankSolution Sage

    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