Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
So I have new sheet in my excel. The excel is already linked to the dashboard, I refreshed my new excel data in share point. The new tab is not visible in power query editor. How can I link this new sheet to already created dashboard. There are multiple steps already applied. The data in the new sheet is same as the previous sheet. If someone can help with an example that would be of great help.
Hello @Tara_01,
I would like to understand/clarify few things:
Does your dashbaord is linked with one Excel workbook, or multiple workbook. One workbook may have multiple work sheet, so are you merging multiple workheets of a workbook and recently added one more worksheet to that workbook or your dashboard is linked to multiple workbooks and recentlty you added one more workbook?
In this post, I see excel file and sheet being used interchangeably, so before proposing any solution, need to confirm that.
If i undestand correctly you already loaded both Sheets in Power BI, if yes, to append two tables in Power Query you must click on Transform Data.
Then on the top menu you will see on the right side an option to choose Append Queries, and you choose both tables.
If both tables have the same number of columns and names you shouldn't have any more problems, you can Close & Apply and the data will refresh.
I hope i could help you!
So this was an already built dashboard earlier in the report that was been refreshed for the dashboard had 4 sheets. Now they have added one more sheet, there are already exsisting queries in query editor I am confused how can I add this new sheet data there. On to which step should I apply this so as it will consider the data from new sheet as well
I'm also confused by the solution that you have at the moment, is it possible to share the pbix so i can help you more?
Hi Tara,
From what i understand you already have loaded that excel file to Power BI, but now you added a new sheet with more data, correct?
If yes, you have or to add the new data in the same sheet/table that you loaded before in Power BI, or load this new sheet as a new table and append it to the other table imported before.
if you need i can guide you with that process.
Hi,
Yes I already have loaded that excel file to Power BI, but now you added a new sheet with more data, the data structure of that sheet is same as the all the old sheets.
I have to add the new data in the same table that I loaded before in Power BI.
But I am confused at which applied step should I do that ?
You cannot add a new sheet with the data, because Power BI will not be able to grab it automatically, you will have to load the new sheet like if it was a new excel file.
But if it has the same structure you can do it in excel, copy the data in the new sheet into the old sheet and append it manually with the older data, or you can do it on Power BI.
To do this in Power BI you have to do get data from excel and select the new sheet, and you will get a new table with the new data, and you can go to Power Query (Transform data) and append the two tables.
After refresh from source can I consider the new sheet will the new sheet be visible after the refresh and then can I make changes in the source ?
By your solution, How will it append with exsisting data ?
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
108 | |
108 | |
93 | |
61 |
User | Count |
---|---|
169 | |
138 | |
135 | |
102 | |
86 |