The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I need an automated way to get an access token during a dataset scheduled refresh. We have powerbi reports which use an odata datasource but the odata datasource requires a token to access the data. Getting the data is not an issue if you are using the powerbi report locally. The issue is when the schedule dataset refresh starts it will require a new access token.
I think the only way may be to add some custom code to each powerbi report to get the access token. But since we have many reports that we use and deploy, this would be an undertaking. Also I am not sure of the custom code to use for this scenario. Any ideas would be really appreciated. Thanks.
Usually processes like these require you to build a custom connector.