Forum Discussion
Power BI Desktop - Data Import
amitchandaklets say we use a power bi machine server. so we manage around 20 companeis and each company should have a user which manages their data and publish the dataset to cloud for users to develop / access the report?. The report will be developed using power bi service? but not all features are there in cloud compared to desktop version. how can we overcome this?
The reqeuirement is dataset should not reside at endpoint meaning pbix file contains dataset. on the other hand if we use live query we cant perform additional transformation and calculations which is a must. We use SAP BW as a data source.
abbas_uddin - I believe your choices are a composite data model where the main data is DirectQuery or to wait until Live queries have similar capabilities. If I am reading the roadmap correctly, the ability to do composite models or something like it are coming to Live queries to Power BI datasets.
Greg_Decklersomewhat it is like that. However we might need to create a semantic data layer between SAP BW and Power BI so users can have direct query without data downloaded. The only challenge will be making the data aggregated according to the requirements from each user or departments.