Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
@tkb,
It seems that you want to display different data in Power BI report based on user authentication. If so, you would need to define Row Level security in Power BI.
In addition, when connecting to web source in Power BI, it is not possible to use Direct Query mode.
Regards,
Lydia
@tkb,
It seems that you want to display different data in Power BI report based on user authentication. If so, you would need to define Row Level security in Power BI.
In addition, when connecting to web source in Power BI, it is not possible to use Direct Query mode.
Regards,
Lydia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.