Forum Discussion

XaviAsme's avatar
XaviAsme
New Member
1 year ago
Solved

Visualization from multiple excel tables

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...
Need Help
  • freginier's avatar
    freginier
    1 year ago

    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 😁😁

     

freginier's avatar
freginier
Solution Sage
1 year ago

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 😁😁