Forum Discussion
Add local Excel files when creating a report in the Service from a Power BI Dataset
If someone can't use Power BI Desktop and only the Power BI Service for creating reports, is it possible for someone to enrich a Power BI Dataset provided in the datasets hub with other (local and/or cloud) datasources?
Hi mmossel
You can get data from local/cloud excel files and then create reports by these excel files in Service .
https://docs.microsoft.com/en-us/power-bi/connect-data/service-get-data
But modeling is limited in Service ,you cannot create measures of or calculated columns .You cannot configure RLS in Service and so on . So in order to better analyze and model the data to maximize the visualization of the data, my suggestion is to use Desktop to model the data, and then use the Service to achieve data sharing and team collaboration.
I found some docs about the differences between Desktop and Service , you can refer to them .
https://docs.microsoft.com/en-us/power-bi/fundamentals/service-service-vs-desktop
https://community.powerbi.com/t5/Community-Blog/Power-BI-Desktop-vs-Power-BI-Services/ba-p/1425481
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi mmossel
You can get data from local/cloud excel files and then create reports by these excel files in Service .
https://docs.microsoft.com/en-us/power-bi/connect-data/service-get-data
But modeling is limited in Service ,you cannot create measures of or calculated columns .You cannot configure RLS in Service and so on . So in order to better analyze and model the data to maximize the visualization of the data, my suggestion is to use Desktop to model the data, and then use the Service to achieve data sharing and team collaboration.
I found some docs about the differences between Desktop and Service , you can refer to them .
https://docs.microsoft.com/en-us/power-bi/fundamentals/service-service-vs-desktop
https://community.powerbi.com/t5/Community-Blog/Power-BI-Desktop-vs-Power-BI-Services/ba-p/1425481
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.