Forum Discussion

Dimani's avatar
Dimani
Icon for Helper II rankHelper II
1 year ago
Solved

Give another user a Power BI Service report for customization?

Hi, New to Power BI Service and Power BI data gateway. We have a report that is using a SQL server connection through the Power BI data gateway. The connection is using my credential. Now a us...
Need Help
  • Dimani's avatar
    Dimani
    1 year ago

    Hi Akhil,

     

    Thanks for following up.  More than a week ago, we set it up for the user to be able to customize our existing reports.  So far, I have not heard anything from the user.  Cannot say whether no news is good news, or he has not tried it.  Usually I take the former.  I think we can consider this is closed.  If we need further assistance, will reach out to the community again.

    Thanks a lot for those who had helped!

     

    Warmest regards,

     

    Dimani

Akash_Varuna's avatar
Akash_Varuna
Icon for Super User rankSuper User
1 year ago

Hi Dimani This issue occurs because DirectQuery requires the other user to have access to the SQL Server database and the data gateway. Grant the user gateway access in Power BI Service and ensure they have database credentials. Alternatively, set up row-level security (RLS) to control data access or grant them Build permission on the dataset to allow custom reports without direct database access.