Urgent : Power Query Help - Authentication Flow

[raduser]

Hey Everyone,

I have an urgent scenario where I want the following to happen:

a)  I authenticate to an API via Power BI and if it returns a success go to step (b)

b)  Retrieve data for a unique id from a sql database and display it in a Power BI report

I am thinking I can probably do something like this:

IF (Person has access) then get data

Else Exit and Show a message

End

Is this possible using Power Query? if yes, can someone please give me some code ideas?

Thanks,

Nimish

[lbendlin]

not yet. ask again in a couple of weeks.

[ImkeF]

Hi @raduser ,

not quite sure about your requirement, but mayby my latest article gives you some ideas: https://www.thebiccountant.com/2020/09/19/retrieve-header-fields-like-response-status-power-bi-and-p...