Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am working on a PBIX with one Excel file as my data source. I have all the graphics and reports I need but now I am receiving a new file to add to my PBIX.
For exmple: I have an Excel file of America's sales which is my data source for PBIX, but now I am receiving Europe's sales in another excel file and I have to add that data to my original PBIX. I can't copy and paste "Europe's sales" data to "America's sales" file. The format of both excel files is the same, I just want to add the new data to my original PBIX and that the graphics and reports show the new data.
Is there a simple way to do that?
If you'd like to add the data as a new table and have both in your report, just use "Get Data" again and select your new file.
To change the data source and replace all US data with Europe data, click "Edit Queries," then "Data source settings," and change to the new Excel file.
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |