Forum Discussion

Marco57's avatar
Marco57
Helper III
5 years ago
Solved

Embedded with Direct Query on Azure SQL - Visual not loading

Hello,   I am embedding my report using Embed for your customer. My report has a DIrectQuery connection to an Azure SQL Database.   I am simply publishing my report to power bi service. When I op...
Need Help
  • Marco57's avatar
    Marco57
    5 years ago

    I solved my issue: It was due to RLS on DirectQuery tables. I had two tables and they need to be in both directional relationship to make RLS work vs single directional in import mode. In case it can help anyone.

  • Marco57's avatar
    Marco57
    5 years ago

    This did not solve the solution unfortunately ... It like solved it temporarly but issue came back in today ... I do not know how to set my above post as unsolved.

Marco57's avatar
Marco57
Helper III
5 years ago

I solved my issue: It was due to RLS on DirectQuery tables. I had two tables and they need to be in both directional relationship to make RLS work vs single directional in import mode. In case it can help anyone.