I'm rather new to PowerBI and we are trying to provide data from a web application to PowerBI for an analytics report. I would like to solve the following scenario:
* The web application provides a REST endpoint that requires authentication of the user in some form (e.g. username/pwd or OAuth) and provides data of a fixed format that the user is allowed to access.
* An analyst is creating a PowerBI report that can pull and processes data of that format and is published in PowerBI services with a data source that retrieves the data when a user looks at the report in PowerBI services
* A user of the web application is directed to the URL of the report in PowerBI service, and when the data for the report is retrieved, the user is authenticated with the REST endpoint (either by entering credentials or by an OAuth flow), and the report is populated with the user specific data.
To my current understanding this means I would need a data source that supports the Direct Query functionality with authentication. Is that correct and can I create such a data source? I experimented already with the SDK for custom data sources and got for example the Github example with the OAuth to work, but as far as I understand that only authenticates the analyst that creates the report to pull the data, but not the user who looks at the report.
