Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a custom connector that connects to Microsoft Graph in order to extract a daily report from a shared mailbox. The oauth works perfectly within Visual Studio and on the desktop application, at least initially. The problem comes when a refresh token is needed for a refresh by the on-premise gateway. The connector doesn't seem to be able to request and apply the refresh token process. Within Visual Studio I can edit the credential, hit refresh, and set it again to get a new refresh token, so I know the refresh function is working at least. I assume this is because there is nowhere to store the refresh token so that it can be used on the next data refresh in order to obtain a new access token. Has anyone been able to get oauth to work with Microsoft Graph using a gateway refresh? Should I instead use an Azure Function to get the data from Microsoft Graph so that I can store the last refresh token within a data store?
Hi @JeffreyKelso ,
What is the error message prompted?
See if these blog will help:
https://www.poweredsolutions.co/2018/04/23/refreshing-a-power-bi-custom-connector-in-the-cloud/
https://www.kasperonbi.com/how-to-enable-scheduled-refresh-for-your-custom-connector/
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
5 | |
5 | |
3 | |
2 | |
2 |
User | Count |
---|---|
9 | |
7 | |
5 | |
4 | |
4 |