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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
sudiptokar
New Member

How do I add new excel sheet data to my existing Power BI Report - Online version

Hi,

I am new to Power BI. I use the online version of Power BI since its on a macbook. I have created a BI report with the data uploaded from an excel sheet with multiple tabs of data. I have a new excel sheet with additional data. How do I upload and link the data and fields from the new excel sheet to the existing Power BI report. I don't have the desktop app hence I need to do it online.

Thanks

Sudipto

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @sudiptokar ,
First of all, we need to make it clear that in the uploaded semantic model of Power BI Service, other data sources cannot be added to it. Here are some of the methods you can try:
The first method is that the datamart you're using requires a Power BI Premium subscription. This allows you to place multiple of your Excel data (old and new) in a datamart and create a new semantic model based on that datamart. You can refer to these two documents.
Get started with datamarts (preview) - Power BI | Microsoft Learn
Create reports using datamarts (preview) - Power BI | Microsoft Learn
In the second way, you can use a virtual machine to download Pwoer BI Desktop, download and open this treasure report, and use Power Query to get the new Excel and merge it. When you're done creating the report, re-upload it to Power BI Service.
How to Download Microsoft Power BI Desktop on Mac OS/ Macbook? - PowerBI Talks
Combine multiple queries (Power Query) - Microsoft Support

Best regards,
Albert He

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

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Hi @sudiptokar ,
First of all, we need to make it clear that in the uploaded semantic model of Power BI Service, other data sources cannot be added to it. Here are some of the methods you can try:
The first method is that the datamart you're using requires a Power BI Premium subscription. This allows you to place multiple of your Excel data (old and new) in a datamart and create a new semantic model based on that datamart. You can refer to these two documents.
Get started with datamarts (preview) - Power BI | Microsoft Learn
Create reports using datamarts (preview) - Power BI | Microsoft Learn
In the second way, you can use a virtual machine to download Pwoer BI Desktop, download and open this treasure report, and use Power Query to get the new Excel and merge it. When you're done creating the report, re-upload it to Power BI Service.
How to Download Microsoft Power BI Desktop on Mac OS/ Macbook? - PowerBI Talks
Combine multiple queries (Power Query) - Microsoft Support

Best regards,
Albert He

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

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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