Forum Discussion
Extract archieve from url with SAML2 authentication
Hi! I'm tryning to extract an Excel archieve received as a url in my outlook using Power Query. I already managed to extract the link in the body of the email and create a new column containing t...
Hi CESAR_OLIVEIRA9 ,
You’ve already extracted the link from the email body and created a new column. Great job!
Now, let’s modify your existing step to include the access token:
#"Carregar Planilha" = Table.AddColumn(
#"Remover Colunas",
"DadosPlanilha",
each Excel.Workbook(
Web.Contents([Link.Anexo], [Headers=[Authorization="Bearer YOUR_ACCESS_TOKEN"]]),
null,
true
),
type table
)Replace YOUR_ACCESS_TOKEN with the actual access token you obtained during authentication.
Similar post:
Solved: How to pull data from Web API into PowerBI using A... - Microsoft Fabric Community
By the way, the token will expire within a certain period of time, so be prepared.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.