Forum Discussion

marco6's avatar
marco6
Frequent Visitor
9 years ago
Solved

Cannot share SharePoint query

Hi all!   I have been developing a report lately. All the data I need comes from a sharepoint list. The list is available online (hosted on <client_name>.sharepoint.com). Offline (PBI Desktop) I ca...
Need Help
  • marco6's avatar
    marco6
    8 years ago

    Hi all! I am writing as I found the source of my problem: if you enable RLS on your dataset, only admin (and not members) users can see all the report. Removing or correctly configuring RLS solves the problem. Still I think this sould be handled differently: if a user doesn't have the permission to access a dataset, the entire report should not be loaded instead of loading it with cryptic errors.

     

    Regards,

    Marco

marco6's avatar
marco6
Frequent Visitor
9 years ago

Hi v-yulgu-msft! Thank you for your answer! Please see the new attached screenshot I took by setting the language to english directly in PowerBI! :)

 

Besides, did this error occur no matter whom you share the dashboard with?

Yes. Seems like the owner account is the only account allowed to see the content. (I am only allowed to share the report with the members of the my client's "organization").

 

Marco

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi marco6,

 

Based on current description, you shared dashborad with external users and organization members, right? Those organization members can view dashboard successfully, while external users see errors, right?

 

Please check:

  • The license those external users owned. If your dashboard contains Pro content, your recipients should also need Pro liscense to view the data. Reference: Share dashboards and reports with colleagues and others
  • Do you have RLS enabled on the data source ? If yes, then it currently is not supported for sharing outside organisation.

.

Regards,
Yuliana Gu

  • marco6's avatar
    marco6
    Frequent Visitor
    9 years ago
    Based on current description, you shared dashborad with external users and organization members, right?

    No, just with organizational members. I am not allowed by contract to share with external users.

     

    Those organization members can view dashboard successfully, while external users see errors, right?

    No one except the me (the owner) can succesfully open the reports.

     

    All the peoples I shared with have an extended trial of the Pro licence (1-year), included me. I am not using RLS in this moment, but I will need to in a next step, in order to fulfil the requirements of my client, but I will never share the report outside of the organization.

     

    Thank you again for your support,

    Marco

     

    • v-yulgu-msft's avatar
      v-yulgu-msft
      Microsoft Employee
      9 years ago

      Hi marco6,

       

      Have you tested to share a dashboard whose data source is not SharePoint to those recipients to check whether they can view report successfully? Also, could you please try to share this dashboard with a user having a Pro license (not the Pro trial) to see whether issue persists? 

       

      Regards,
      Yuliana Gu

      • marco6's avatar
        marco6
        Frequent Visitor
        9 years ago

        Hi v-yulgu-msft!

         

        Have you tested to share a dashboard whose data source is not SharePoint to those recipients to check whether they can view report successfully?

        Yes I did! I have been sharing dashboards using Push API for few month without any problem.

         

         

        Also, could you please try to share this dashboard with a user having a Pro license (not the Pro trial) to see whether issue persists?

        I don't think I can as neither the client nor I own a Pro license. Also, I don't think a "Pro" trial should limit my business as its scope is to make me understand how valuable is PowerBI to me or my client.

         

         

        Thank you for your answer,

        Marco