Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
Tara_01
Helper II
Helper II

Added new sheet in excel but the same is not reflecting in powerbi applied steps

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.

8 REPLIES 8
mahenkj2
Solution Sage
Solution Sage

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.

SergioSilvaPT
Resolver V
Resolver V

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.

SergioSilvaPT_1-1652379950760.png


Then on the top menu you will see on the right side an option to choose Append Queries, and you choose both tables.

SergioSilvaPT_0-1652379926303.png

 

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!

Regards,
Sérgio Silva

If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Check out my blog for tips and tricks about Power BI: https://pbibits.wordpress.com/

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?

Regards,
Sérgio Silva

If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Check out my blog for tips and tricks about Power BI: https://pbibits.wordpress.com/
SergioSilvaPT
Resolver V
Resolver V

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.

Regards,
Sérgio Silva

If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Check out my blog for tips and tricks about Power BI: https://pbibits.wordpress.com/

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. 

Regards,
Sérgio Silva

If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Check out my blog for tips and tricks about Power BI: https://pbibits.wordpress.com/

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 ? 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.