Forum Discussion

directvman67's avatar
directvman67
Frequent Visitor
9 months ago

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...
Need Help
directvman67's avatar
directvman67
Frequent Visitor
8 months ago

Thank you for your video.  Very interesting and well done.  That being said, here are some comments and my results trying all the things in your video:

 

I am not sure why you say I need a custom connector.  I have a single query that returns the API key and simply use that as my bearer token in the next query that calls for the status data.  That being said, as I said in a previous comment, even if I hard code the Bearer token (to one that is fresh and active), I still get this same PowerBI error.

 

I also tried all these things (many mentioned in your video), and none succeeded. 😥

  • Break things into multiple steps
  • Set Privacy Levels all same
  • Ignore Privacy Levels
  • Set Skip Test Connections on all data sources
  • Try using functions
  • Try using one big query
  • Try splitting into smaller queries
lbendlin's avatar
lbendlin
Super User
8 months ago
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.

  • cpwebb's avatar
    cpwebb
    Microsoft Employee
    8 months ago

    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.