Solved: Button to Sign-Off URL Filter

DanielLinda · ‎05-18-2020

Hello Power BI developers,

I'm embedding my report with Iframe and as I know there are some possibilities to make some button with low-code.

I want to make button to sign-off current signed user.

If it is possible then please give me any idea.

Plus, if any code snippet to make button to sign-in will be appreciated as well.

Thanks in advance.

v-lid-msft · ‎05-20-2020

Hi @DanielLinda ,

We create a sample to add a button in html, when click it, it will open a sign-out tab, it can be achieved better by using js script to call a background http request to sign out.

<!doctype html>

<html lang="en">
<head>
  <meta charset="utf-8">
  <title>Sign Out Power BI</title>
</head>

<body>
<script src="js/scripts.js"></script> 
<H1> Signout Test</H1>

<a href="https://app.powerbi.com/Signout" target='_blank'>
 <button type="button"> Signout Current User </button>
</a>
<br />

<iframe width="1140" height="541.25" src="https://app.powerbi.com/reportEmbed?reportId=XXX&autoAuth=true&ctid=XXX&config=XXX" frameborder="0" allowFullScreen="true"></iframe>

</body>
</html>

the signout request will like following:

curl 'https://app.powerbi.com/Signout' \
  -H 'authority: app.powerbi.com' \
  -H 'pragma: no-cache' \
  -H 'cache-control: no-cache' \
  -H 'upgrade-insecure-requests: 1' \
  -H 'user-agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.138 Safari/537.36' \
  -H 'accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9' \
  -H 'sec-fetch-site: cross-site' \
  -H 'sec-fetch-mode: navigate' \
  -H 'sec-fetch-user: ?1' \
  -H 'sec-fetch-dest: document' \
  -H 'referer: https://login.microsoftonline.com/' \
  -H 'accept-language: en;q=0.9,zh;q=0.8' \
  -H 'cookie: ASP.NET_SessionId=XXXXXXX; ARRAffinity=XXXXXXXXX; PreferredLanguage=; ai_user=MCng0|2020-05-20T03:04:08.184Z; ClusterUri=XXXXXXXXX=https://XXXX-XXXXX-east-redirect.analysis.windows.net/; OpenIdConnect.nonce.XXXXX; ai_session=Uluum|XXXX|XXXX.105; LoginErrorReattemptCount=2; WFESessionId=XXXXX' \
  --compressed

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-lid-msft · ‎05-18-2020

Hi @DanielLinda ,

Based on my test, if visit "https://app.powerbi.com/Signout" , it will sign out the user of power bi, how about make a button which have hyperlink to the https://app.powerbi.com/Signout. When click the button, it will open a new tab and the current power bi page will signout in few seconds.

Or create the button outside the report, it should do the same thing.

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

DanielLinda · ‎05-19-2020

For example, I want to make button to sign-off current user in below page.

I'm using html file with Iframe to connect this page.

v-lid-msft · ‎05-20-2020

Hi @DanielLinda ,

We create a sample to add a button in html, when click it, it will open a sign-out tab, it can be achieved better by using js script to call a background http request to sign out.

<!doctype html>

<html lang="en">
<head>
  <meta charset="utf-8">
  <title>Sign Out Power BI</title>
</head>

<body>
<script src="js/scripts.js"></script> 
<H1> Signout Test</H1>

<a href="https://app.powerbi.com/Signout" target='_blank'>
 <button type="button"> Signout Current User </button>
</a>
<br />

<iframe width="1140" height="541.25" src="https://app.powerbi.com/reportEmbed?reportId=XXX&autoAuth=true&ctid=XXX&config=XXX" frameborder="0" allowFullScreen="true"></iframe>

</body>
</html>

the signout request will like following:

curl 'https://app.powerbi.com/Signout' \
  -H 'authority: app.powerbi.com' \
  -H 'pragma: no-cache' \
  -H 'cache-control: no-cache' \
  -H 'upgrade-insecure-requests: 1' \
  -H 'user-agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.138 Safari/537.36' \
  -H 'accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9' \
  -H 'sec-fetch-site: cross-site' \
  -H 'sec-fetch-mode: navigate' \
  -H 'sec-fetch-user: ?1' \
  -H 'sec-fetch-dest: document' \
  -H 'referer: https://login.microsoftonline.com/' \
  -H 'accept-language: en;q=0.9,zh;q=0.8' \
  -H 'cookie: ASP.NET_SessionId=XXXXXXX; ARRAffinity=XXXXXXXXX; PreferredLanguage=; ai_user=MCng0|2020-05-20T03:04:08.184Z; ClusterUri=XXXXXXXXX=https://XXXX-XXXXX-east-redirect.analysis.windows.net/; OpenIdConnect.nonce.XXXXX; ai_session=Uluum|XXXX|XXXX.105; LoginErrorReattemptCount=2; WFESessionId=XXXXX' \
  --compressed

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

DanielLinda · ‎05-20-2020

Thanks @v-lid-msft,

I might use your code and it will be enough.

Thanks for your kind support.

Greg_Deckler · ‎05-18-2020

No idea if this would work but maybe a link to a web page that does the sign-off? What are you signing them off of?

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Button to Sign-Off URL Filter

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024