Forum Discussion
Custom Connector OAuth across functions not available
I'm working on multiple custom connectors that retrieve data from REST APIs. Over and over, I need to utilize the result of one query as input for another. For instance, I get a result/table of X thi...
That error looks quite familiar. I'm guessing it's a data privacy issue.
https://blog.crossjoin.co.uk/2017/06/26/data-privacy-settings-in-power-bipower-query-part-3-the-formula-firewall-error/
Indeed. Disabling data privacy does allow the function that's shared through the NavTable to "work".
I guess I still have two things I'm confused about:
- Is there any way around this when using a Data Connector table as the input? Following Chris's blog post, the "NaiveQuery" approach isn't an option. Looking at other proposed methods of breaking the list out into another query always lands me back at the Firewall issue.
- Why doesn't it see my second function, when not exposed through a NavTable, as being part of the Data Connector? It's shared. I get Intellisense for it. But it throws that errors. I'd probably get the same Firewall issue, but I'm just confused by that piece. Can a user only access what is exposed through a Publish route, technically?