Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I've connected to an on premises SSAS data source with Power BI Desktop and could successfully publish to the web.
I would like to share the datasets themselves with users outside my organisation so that they can drag/drop the dimensions/measures and create reports and dashboards or reports that they would like to see.
From what I've read it's only possible to share preconfigured dashboards and reports with users outside my organisation. Could someone please tell me if it is possible to share the datasets themselves with users outside my organisation?
Hi @bkokster,
Tested it on my local environment with my colleagues.
If we create a content pack and publish to my colleagues. then they can get the dataset. To create a report based on this dataset, they need access permission to SSAS database.
https://powerbi.microsoft.com/en-us/documentation/powerbi-service-organizational-content-pack-tutori...
If we use Analyze in Excel feature, and send ODC file to colleagues, they also need access permission to SSAS database.
https://powerbi.microsoft.com/en-us/documentation/powerbi-service-analyze-in-excel/
So in your scenario, in order to share the datasets themselves with users outside your organisation, and allow them to create report base don the dataset, the uers need to have the access permission to SSAS database.
Regards,
Charlie Liao
Hi, for now you cannot share a dataset, if you want to do that kind of things, you should create a template and publish the template via Power BI, however that is not possible with Analysis Services.
More information https://powerbi.microsoft.com/en-us/documentation/powerbi-service-share-unshare-dashboard/
Regards