Forum Discussion
Isssue Adding Web.Content Column to Web Data
I am hoping someone will read this and have a solution. I will try to keep my post as brief as possible, but also with enough detail to understand the current situation. I have a PowerBI dashbo...
I am not sure why you say I need a custom connector.You need that if you want to refresh that semantic model in the Power BI service.
Just to add to that (and to reiterate some of the points made in my blog post linked to above): if I'm correct that you're trying to connect to an API that requires OAuth2 authentication, the reason you need to build a custom connector is that Power Query/M as it exists today in Power BI and Excel do not have the functionality required to support doing this in a reliable and secure way. The functionality only exists in custom connectors.