Forum Discussion
Solved
Sharing data sets
Hi, What is the easiest way of sharing a dataset deployed as pbix file, I would like my colleagues at my organization to connect to the dataset from Excel at their local laptops over internet and ru...
Hi jerics99,
Content Packs are only available when you and your colleagues have Power BI Pro. Reference: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-organizational-content-packs-introduction/ .
As you want to share a dataset with colleagues that use the free license, you can copy the PBIX file out to a folder and share the folder to your colleagues, from my point of perspective, this is what smoupre means by sharing. There is no option in Power BI desktop to share PBIX file.
Thanks,
Lydia Zhang
jerics99
I haven't tested it but think it will work. You should create a report and publish that to power bi service. Then share that report with your colleagues which will give them access to your dataset though they can't see it listed under their datasets. Then they should be able to use Analyze in Excel feature which will let them connect to the published dataset from excel on desktop. Only thing I'm not sure of is if Analyze in Excel feature will be available with shared report since your colleagues won't be the owner of report. You can test this out and let us know.
I haven't tested it but think it will work. You should create a report and publish that to power bi service. Then share that report with your colleagues which will give them access to your dataset though they can't see it listed under their datasets. Then they should be able to use Analyze in Excel feature which will let them connect to the published dataset from excel on desktop. Only thing I'm not sure of is if Analyze in Excel feature will be available with shared report since your colleagues won't be the owner of report. You can test this out and let us know.
jerics99 Unfortunately Analyze in Excel is not available with shared reports. Therefore you won't be able to use the way I suggested. Do as Greg_Deckler said.