Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
We have not been able to share datasets in my organization even with the Pro licenses...?
Background: I would like to let different users in my organization use excel pivot tables using a shared dataset as data source. I have not managed to get that to work though. I have published at Power BI Desktop model to Power BI, but unfortunately I am the only user that can query the data set even though its included in a Group shared with other users....?
For your information. Our initial plan was to set up a virtual machine with SSAS in our Azure instanse, but it got fairly expensive so we instead thought that Power BI would be a better alternative.
Kind Regards,
-Eric
Solved! Go to Solution.
Hi Eric,
I dont believe that the .ODC file that you create with the analyze in excel thingy is shareable. I could be 100% wrong but I suspect that it will only work if:
Each user who needs access to the data file has a working PowerBI service account and
Each of those users has the analyze in excel addin ininstalled.
The sharing wont make any difference to the .ODC file that you are wanting to use. The sharing only applies (atm) to powerbi not the progeny ie data connection of.
Keep me posted as I am keen to here how you go with this one.
Cheers,
Sam
Hi @jerics99,
Based on my understanding, you have created a report in Power BI Desktop use the data returned from Excel. Then you publish the report to a group workspace, the group member can't use this dataset to create a report, right?
Currently, Power BI product team is working on this feature request, the feature will be available as soon as possible. If you have any suggestion, you can comment on this Idea item: Ability to share datasets or connection to other users.
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu
Hi, this issue was solved by Microsoft, and sharing works fine now.
Hi @jerics99,
Based on my understanding, you have created a report in Power BI Desktop use the data returned from Excel. Then you publish the report to a group workspace, the group member can't use this dataset to create a report, right?
Currently, Power BI product team is working on this feature request, the feature will be available as soon as possible. If you have any suggestion, you can comment on this Idea item: Ability to share datasets or connection to other users.
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu
Hi, this issue was solved by Microsoft, and sharing works fine now.
Hi Qiuyun_Yu,
1) Well, I created a Model in Power Bi desktop that I published to Power BI.
2) Then I Created a Pivot Table in an Excel file against the data source (model) published in Power BI
3) I created some calculated members in the Excel file based on the pubished model /this is a great way of creating report specific KPI:s, expecially for users that like to work with Excel locally with a datasource in Power BI.
I can store the excel file locally and open it and refresh the data etc
Problem: However its only my Power BI user that can use the excel sheet, I would like to share the excel sheet with others in my organization and when they refresh the data in the pivot table they should connect to the datasource (model) published in Power BI with their user accounts.
Kind Regards,
-Eric
Hi Eric,
I dont believe that the .ODC file that you create with the analyze in excel thingy is shareable. I could be 100% wrong but I suspect that it will only work if:
Each user who needs access to the data file has a working PowerBI service account and
Each of those users has the analyze in excel addin ininstalled.
The sharing wont make any difference to the .ODC file that you are wanting to use. The sharing only applies (atm) to powerbi not the progeny ie data connection of.
Keep me posted as I am keen to here how you go with this one.
Cheers,
Sam
I dont believe that the .ODC file that you create with the analyze in excel thingy is shareable. I could be 100% wrong but I suspect that it will only work if:
Each user who needs access to the data file has a working PowerBI service account and
Each of those users has the analyze in excel addin ininstalled.
The sharing wont make any difference to the .ODC file that you are wanting to use. The sharing only applies (atm) to powerbi not the progeny ie data connection of.
Keep me posted as I am keen to here how you go with this one.
Cheers,
Sam
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.