Forum Discussion
refresh excel with altered column names
Kvisborg,
"I would like to compare and sum several months"
In this case, please put all excel files to a local folder, then use Folder connector in Power BI Desktop to connect to the data source. Please make sure that the table structure in all the original excel files are same(same columns, same column names). After that, you can rename columns in Power BI Desktop, create report in Desktop, publish report to Power BI Service.
In Power BI Service, you can set schedule refresh for the dataset after configuring gateway and adding the Folder within gateway.
Regards,
Lydia
Do you use web connector in Power BI Desktop? What data would you like to get in Power BI report? Data of all months or data of the latest month?
Regards,
Lydia
I choose this:
1) Get Data from Excel
2) And then I pick the specific excel sheet from my OneDrive
3) And then load it up to PBI desktop
Starting up, I only have data for the previous month, but as time goes I would like to compare and sum several months
Best
Kvisborg,
"I would like to compare and sum several months"
In this case, please put all excel files to a local folder, then use Folder connector in Power BI Desktop to connect to the data source. Please make sure that the table structure in all the original excel files are same(same columns, same column names). After that, you can rename columns in Power BI Desktop, create report in Desktop, publish report to Power BI Service.
In Power BI Service, you can set schedule refresh for the dataset after configuring gateway and adding the Folder within gateway.
Regards,
LydiaTHANk you so much!
also for your patience :)
Good day
//Kvisborg