Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
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.
Solved! 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?
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |