Those workarounds revolve around separating each query with a different source and making them feed their information to a third query where they can be combined freely. I have found solutions online that do not require the change of privacy levels, however the solution does not seem applicable to my scenario. Having my users enter Power Query Editor to make changes themselves in the privacy levels is not viable. It is possible to make the queries work by changing the privacy levels setting, but this setting is apparently unique to each user even if you change it at workbook level. The problem with this is that the default privacy settings for a query does not allow for two queries with different sources to interact - information from the spreadsheet (source 1) may not be used in the API query (source 2).įormula.Firewall: Query 'ORSMatrixBase' (step 'Source') references other queries or steps, so it may not directly access a data source.
Those parameters are collected in a separate query and are then called in the API call query. The API call relies on parameters entered by the user in the spreadsheet. The data in question is the distance and time (output) between a set of coordinates (input).
I am creating an Excel file that is going to allow users to enter a few parameters in a spreadsheet and press a button to call an API that fetches and presents the data they are after.