This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 15%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Hi there,
I got my first question deleted, could you please tell me what I did wrong? Previous question
I'm going to try a different approach. What I want to do is:
Make an API request to the Data API Builder feature through Power Query in Excel.
I've deployed an Azure Static Web App to host the Data API Builder feature, I've done all the configuration and followed the available tutorials. I've got the whole thing working fine, but I'm only able to pull data through the internet browser, when I try to pull it using Excel, it seems that the authentication flow can't redirect to the original URL and gets stuck on the /.auth/complete page.
What else should I do to be able to pull data through Excel? I noticed that if you get rid of all the security layers, I mean AAD, the redirect error doesn't occur, so that reinforces my thought about the auth flow.
Thank you!
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 55.00000000000001%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Apologies your previous question was deleted ( I'll relay the feedback internally to the platform team)
Please let us know what docs/tutorials are you referring to, for the steps.
For specific question on Power Query, you may always just re-post it on here: https://community.fabric.microsoft.com/t5/Power-Query/Welcome-to-the-Power-Query-forum/td-p/1985552 - To receive insights from the dedicated SMEs/community experts on Power Query.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 95%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPZ%3C/text%3E%3C/svg%3E)
seems that the authentication flow can't redirect to the original URL and gets stuck on the /.auth/complete page Do you rent a web host?what authentication flow? if static web,there are no way to authorize fetch .html page as far as i know.