Azure Static WebApp: How do I call it from Power Query

Question

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!

Answer 1

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.