Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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
Solved! Go to Solution.
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
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
12 | |
8 | |
8 | |
7 |
User | Count |
---|---|
15 | |
13 | |
9 | |
7 | |
6 |