cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Report refresh query - Implementing-testconnection-for-gateway-support

Dear Forum Members,

I have created a custom data connector which uses a REST service to authenticate user and based on user access on certain database(s) (table, columns, data) user(s) can view the report, I have published this report using PowerBI, I can see the published report with the dataset. Initially refreshing was an issue but I managed to resolve using the below link:



<A href="https://community.powerbi.com/t5/Developer/The-given-data-source-kind-is-not-supported/td-p/481663" target="_blank">https://community.powerbi.com/t5/Developer/The-given-data-source-kind-is-not-supported/td-p/481663</...>





Question here is - I have designed the report with the view that authorised report user (finance/sales/operations) will be using it and based on the user credential data will be fetched - suppose he is only allowed to see "A", "B" and "D" but not "C" whereas the same report when open by the another user he will be able to only see "C" - Based on windows user. Customer connector takes the windows user credentials and then bring the data which user has access to. This scenario works fine for a developer/admin perspective but once report is published this will not work - custom connector dataset gets refreshed by the admin/scheduled jobs which will bring the data as per admin/developer access but the user who is refreshing the report will only see the data changes but user access level will not be controlled using this architecture?



Examples:



Finance report users - allowed to see certain accounts so when they run the report - they can only view their allowed data.



Sales report users - allowed to see certain accounts so when they run the report - they can only view their allowed data



Summarising my question - Intention was to create a data connector which will fetch the data out based on the user access level and permissions which we define using custom authentication, it seems like only admin can refresh the report so there is no point of authenticating users as data will be fetched or refreshed based on the connector which has admin or any developer credentials.



I can only see you need another layer within Power BI to filter the data as per the user, is this correct?



Please kindly advise.

0 REPLIES 0

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.