Forum Discussion
Visualization from multiple excel tables
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 😁😁
Community SupportHi 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.