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 can see all the data, I can update everything and I can see all the dashboards.

 

If I upload on powerbi.com the dashboard (I have a pro license) eveything seems to work as expected. However, if I try to share with another user the report (this users has a pro license, too; moreover, this user is in the same domain of mine) I get this result, no matter what:

 

 

Clicking on "Visualizza dettagli" ("View details") results in:

 

 

As a last note, I needed to go to "Settings" and specify "OAuth2" as authentication method (and insert again online my credentials) in order to be able (from my account) to update the dataset (and schedule a daily update as well).

 

What am I doing wrong? How can I proceed?

 

Thank you,

Marco

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

10 Replies

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

    Hi marco6,

     

    What did the error message point to? Please translate the detailed error information into English.

     

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

     

    Regards,
    Yuliana Gu

    • 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