Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Direct Query - Access rights

Hello,  I need the help of the community to understand if the situation I am facing is a limitation or a bad setting.  We are using direct query to power bi dataset for creating multiple reports.  ...
Need Help
v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
4 years ago

Hi Anonymous ,

According to your description, you create a report connecting to dataset in DirectQuery mode, in this way, it will generate a new dataset corresponding to the report. In order to access this report, you just need to grant permission to the new dataset.

 

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi

Following multiple tests I have to say the only way I found to grant access to the final report report is to give permission on the original dataset. I would be happy to hear from you how to proceed to bypass this restriction and have an independent dataset. 
thanks 

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    4 years ago

    Hi Anonymous ,

    Sorry yesterday I use the dataset create a blank report and can access the blank report without the original dataset permission, but today I test with visuals in the report and the visuals can't load successfully until I grant permission to the original dataset. This was my oversight, I apologize again.

     

    Best Regards,
    Community Support Team _ kalyj