Forum Discussion

rsb_powerbi's avatar
rsb_powerbi
Frequent Visitor
9 years ago
Solved

Power BI Embedded Row Level Security, Couldn't load data for this visual 401 error

Hello! Using the Sample at: https://docs.microsoft.com/en-us/azure/power-bi-embedded/power-bi-embedded-get-started-sample And following the article at: https://docs.microsoft.com/en-us/azure/powe...
Need Help
  • rsb_powerbi's avatar
    rsb_powerbi
    9 years ago

    Hello Eric,

    Thanks so much for your help, as it really narrowed down where the problem was.

    It looks like the issue was with one of the packages, which was not working with RLS corectly - but would work without it. I must have taken a version from before RLS was implemented.

    After updating all packages with NuGet to the latest working versions it now works with RLS correctly.

    Hopefully this is of help to anyone with the same problem.

     

     

Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
9 years ago

rsb_powerbi

The token actually works for me when My pbix just contains one table. Do you mind uploading the pbix? I'd like to check the RLS setting in your case.

var embedToken = PowerBIToken.CreateReportEmbedToken(this.workspaceCollection, this.workspaceId, report.Id,"10005",new string[] { "provider"});

Check the simple pbix in my test.

 

  • rsb_powerbi's avatar
    rsb_powerbi
    Frequent Visitor
    9 years ago

    Hello Eric, 

    I tried uploading your power BI File and i received the same error as with my powerbi file.

    However, if i remove the RLS from your file and then upload it it works fine.

     

     

  • rsb_powerbi's avatar
    rsb_powerbi
    Frequent Visitor
    9 years ago

    I also tried recreating my embedded workspaces/starting the sample from scratch again. 

    Still with the same issue.

    • Eric_Zhang's avatar
      Eric_Zhang
      Microsoft Employee
      9 years ago
      rsb_powerbi wrote:

      I also tried recreating my embedded workspaces/starting the sample from scratch again. 

      Still with the same issue.

      rsb_powerbi

      Would you mind share your application? You can share me a github link or a zipped folder.

      • rsb_powerbi's avatar
        rsb_powerbi
        Frequent Visitor
        9 years ago

        Hello Eric,

        I have Messaged you a link for the zipped application file