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.
When I add the table name to the OData source URL (the one that I use to get all the tables to select from) my query directly returns that particular table. After I publish my report to Power BI service, I no longer see OAuth2 available in the authentication method which prevents me from scheduling refresh.
The reason I add the table name is to apply filtering to the source.
I would highly appreciate any help.
Thank you
Hi @theblueslover ,
For custom connectors to work with the on-premises data gateway, they need to implement a “TestConnection” section in the custom connector’s code.
The method for implementing TestConnection functionality is likely to change while the Power BI Custom Data Connector functionality is in preview.
For more details, please check this document.
https://docs.microsoft.com/en-us/power-query/handlinggatewaysupport
Best Regards,
Jay
Thank you for your reply. The data I'm retrieving is on-cloud and when I do not add any filters to the OData url I can authenticate using OAuth2 and schedule refresh without any on-premise data gateway.
Would there be any other options that I should take into consideration?
Thank you.
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.