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.
Solved! Go to Solution.
Hi @Sac,
You can place those Excel files in one folder, then in Power BI desktop, connect to this folder via Folder data source, use Combine Files feature. Please note the Excel structure need to be the same, eg: table name and column name. See: Combine binaries in Power BI Desktop.
When you receive the new Excel file, you can put it in this folder. Refresh in desktop you can get data both from old files and new file. After publish to service, you need to create a Folder data source under data gateway then configure the dataset to use this data gateway.
Best Regards,
QiuyunYu
Hi @Sac,
You can place those Excel files in one folder, then in Power BI desktop, connect to this folder via Folder data source, use Combine Files feature. Please note the Excel structure need to be the same, eg: table name and column name. See: Combine binaries in Power BI Desktop.
When you receive the new Excel file, you can put it in this folder. Refresh in desktop you can get data both from old files and new file. After publish to service, you need to create a Folder data source under data gateway then configure the dataset to use this data gateway.
Best Regards,
QiuyunYu
Hi @Sac
Can you please provide more details around what you are wanting to do?
If it is another file that you want to append to an existing file, in the Query Editor there is an option to Append the data together.
Dear,
Actually i want to set up auto refresh. I am working on the project in which suppiler sends us report in excel file every month. I already make model and dashboard. Now Quetion is .
Next month , when i got a new excel file from suppiler then i want to set up auto refresh and the data of that new excel file will append to my exiting excel file in power bi .
Hi @Sac
Is it going to be a new file or overwrite the existing file?
If it is going to overwrite the existing file then on refresh it will load all the contents of the file. So your historical data if not contained within the Excel file will get lost.
No. Actually i want to keep my historical data as it is and append only new data to that file. Do you have any way to do this other than this ?
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.