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.

Marco57's avatar
Marco57
Helper III
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.