I want to add a new sheet of data to my Power BI each month.
I found out how to merge excel sheets in Power BI.
But I am unsure about how I change the data source so it points towards the merged file, as it only seems to live in Power BI.
So I have data from January, where I have done some calculations etc.
Now I want to add the February data.
Go to Solution.
I go to:
Get data->More->File->Folder->Folder path
I have my two files in there.
So I end up with one sheet titled the folder path name.
Are you merging or appending?
Proud to be a Datanaut!
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!