Problem caching permission of shared data source

[tringuyenminh92]

Hi guys,

I have shared permission to another user to own my data source.

So he creates report with Direct Query and using my gateway. It's working. After that, I remove his permission, but he still able to use my gateway with out any error. My expectation is

I think the problem that permission has been cached in browser or his loggin session, so he has to sign out and close his browser, so this new change (removing permission) will be affected. I think it should be affected immediately when removing his permission.

[v-qiuyu-msft]

Hi @tringuyenminh92,

Based on my test, remove the permission for the user to use data source created under data gateway, the published report will throw error as no gateway configured after refresh the report page.

In your scenario, please click Refresh button in report page. Also please keep the data gateway to the latest version.

Best Regards,
QiuyunYu

[tringuyenminh92]

Hi @v-qiuyu-msft,

I'm using Direct Query mode for that report to ensure the error will be displayed, but it did not.

The gateway version is 14.16.6390.2 (i think it's the newest).

[v-qiuyu-msft]

Hi @tringuyenminh92,

I also tested with DirectQuery mode to SQL Server. What if you remove the user, then let the user click Refresh button in report page? Make sure the account to access report is that removed user.

Best Regards,
QiuyunYu

[tringuyenminh92]

Hi @v-qiuyu-msft,

He is owner of that report, but his report is using my gateway @v-qiuyu-msft. I will try re-produce your suggestion and let you know soon.