Visualization from multiple excel tables

[XaviAsme]

Hello Community,

I am new to Power BI, and I still struggle with differentiating which features are only available for Power BI Desktop and which are available for Power BI online (I can only use the latter). I have been asked to create visualizations that merge Excel tables from different sheets and to find relations between the tables, but I have only managed to create reports and visuals from a single table.  

I would like to know if this is possible for Power BI online and, if so, which would be the most straightforward approach to achieve it. 

Thank you! 

[v-menakakota]

Hi @XaviAsme ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-menakakota]

Hi @XaviAsme ,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

Thank you.

[v-menakakota]

Hi @XaviAsme ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[freginier · Accepted solution]

Hi there! 

Yes! Power BI Online can work with multiple Excel tables, but it has limited data modeling capabilities compared to Power BI Desktop. You can:

- Upload multiple Excel sheets to OneDrive or SharePoint.
- Create relationships between tables using the Power BI Model in the Service.
- Use the "Merge" and "Append" features in Power Query (in Power BI Online).

Hope this makes it more clear for you 😁😁

[v-menakakota]

Hi @XaviAsme ,

Thank you for reaching out to us on the Microsoft Fabric Community Forum.
Since you are using Power BI Service (Online) and cannot use Power BI Desktop, here’s how you can merge and visualize data from multiple Excel sheets:

Open Power BI Service. Navigate to Workspace and select New Item > Dataflow Gen2 to import your Excel files.  Create a Lakehouse under New Item and send both tables to the same Lakehouse.
 Access the SQL Analytics Endpoint from the top-right corner to work with your data.

Next, go to Model Layouts in the top left corner, where you can define relationships between both tables.

Use the Report View to build charts and visuals.  Use the Fields pane to drag columns from different tables into visuals.  If needed, use DAX measures for calculations across tables.Now you can create reports and visuals from a single table.  

If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.