Hi
We have the following scenario that is being explored (all on-prem based):
- A user logs onto Power BI Report Server using ADFS for authentication/authorization
- A report is made accessible to the logged on user that retrieves its data in realtime (DirectQuery mode) from a custom source e.g. an OData based API
- The custom data source accepts the authentication/authorization details (token/claims) already available (in some way) and uses them to ensure only the relevant data is made visible in the report for that user
The assumptions we are working with at the moment are:
- Create a custom security extension for Report Server to provide ADFS authentication capabilities
- Create a custom connector that is able to pass the authentication/authorization details through to the data source
- Build the data source (Web API/OData feed) so that it filters the data according to the authentication/authorization details provided e.g. token/claims
We are looking for guidance with:
- How to create a custom connector that supports Direct Query to a custom OData source (without an ODBC driver)
- How to build the custom connector so that it can "pass through" the credentials to the data source
Pointers to relevant articles or examples that would help with this would be greatly appreciated.
Most articles already read suggest that building a custom connector that supports DirectQuery can only be done via an ODBC driver...is that still the case or has anyone already achieved this...?
CData provides connectors that support DirectQuery capabilities, however these do not appear to support passthrough of authentication/authorization details to the underlying data source.
Thanks in advance for any help provided.
