Forum Discussion

jerics99's avatar
jerics99
Frequent Visitor
10 years ago
Solved

Share Data

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 ...
Need Help
  • samdthompson's avatar
    samdthompson
    10 years ago

    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

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    10 years ago

    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

  • jerics99's avatar
    jerics99
    9 years ago

    Hi, this issue was solved by Microsoft, and sharing works fine now.

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
10 years ago

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

jerics99's avatar
jerics99
Frequent Visitor
10 years ago

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