Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I have an excel file where the data is hosted locally on my computer. My issue is that each month I get a new excel workbook with the "new month's data" but I don't want to go through the cleaning process.
So for example spreadsheet 1 comes with data which I clean in PowerBI, import, update field types etc. - now I create my report with various visualisations for this month.
In month 2 I have a new spreadsheet with the exact same data layout (spreadsheet 2). I want to add this data into my report and keep last month's data (to allow comparitive analysis).
What is the most effecient way to import this into PowerBI (and avoid redoing the cleaning, etc) and update my report with the fields in the new report without having to manually edit each visualisation and drag the relevant field to each visualisation?
Solved! Go to Solution.
Hi @zaheerahmed ,
For your requirement, I think you could try to use Query Parameter in Power BI.
Please refer the suggestion of PattemManohar in this similar thread which should be helpful. You could get the monthly data firstly and then append the queries so that you could keep the previous data and the latest data in one table to show the comparison.
In addition, this solution may be a choice either.
Best Regards,
Cherry
Hi @zaheerahmed ,
For your requirement, I think you could try to use Query Parameter in Power BI.
Please refer the suggestion of PattemManohar in this similar thread which should be helpful. You could get the monthly data firstly and then append the queries so that you could keep the previous data and the latest data in one table to show the comparison.
In addition, this solution may be a choice either.
Best Regards,
Cherry
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |