https://community.fabric.microsoft.com/t5/Developer/Auto-Generate-Embed-Token-using-Javascript-and-PHP/m-p/1317620#M25404 <P>I can't be the only one that has run into this.</P><P>I have seen the ones for creating a function but I can't seem to get that to work either.</P><P>Has anyone gotten this to work with PHP and javascript?</P><P>Maybe a different authentication method would be better? Not sure what other options there might be.</P> Sun, 23 Aug 2020 21:07:55 GMT Noobtastic_com 2020-08-23T21:07:55Z https://community.fabric.microsoft.com/t5/Developer/Auto-Generate-Embed-Token-using-Javascript-and-PHP/m-p/1316556#M25399 <P>I have gotten my report working in test with a token generated using the Microsoft Embed Token - Generate Token (here&nbsp;<A href="https://docs.microsoft.com/en-us/rest/api/power-bi/embedtoken/generatetoken" target="_blank" rel="noopener">https://docs.microsoft.com/en-us/rest/api/power-bi/embedtoken/generatetoken</A>) and by using the PowerShell commands.</P><P>I got the formatting just right, changed some config and got it all working just how I wanted it on localhost.</P><P>To try figuring it out, I also used the automated Embedded setup via powerbi.com (here&nbsp;<A href="https://app.powerbi.com/embedsetup/appownsdata" target="_blank" rel="noopener">https://app.powerbi.com/embedsetup/appownsdata)</A>. I played around with the downloaded vs files which shows that generating the token on the fly is possible but it is all ASP.net and C# and I can't figure out how to convert it.</P><P>Now I am trying to get it deployed to production into my site which uses PHP and javascript.</P><P>Does anyone have some samples or anything where I could swap out my ReportId, GroupId, etc? Script kiddie style...</P><P>Here is what I am using that works perfectly, except for the expiring manually generated token:</P><P>&nbsp;</P><LI-CODE lang="javascript">&lt;script src="./dist/powerbi.js"&gt;&lt;/script&gt; &lt;div id="reportContainer" style="height: 1400px; width: 1000px;"&gt;&lt;/div&gt; &lt;script&gt; // Get models. models contains enums that can be used. var models = window['powerbi-client'].models; // Embed configuration used to describe what and how to embed. // This object is used when calling powerbi.embed. // This also includes settings and options such as filters. // You can find more information at https://github.com/Microsoft/PowerBI-JavaScript/wiki/Embed-Configuration-Details. var embedConfiguration = { type: 'report', tokenType: models.TokenType.Embed, accessToken: '&lt;manually generated token here&gt;', embedUrl: 'https://app.powerbi.com/reportEmbed', id: '&lt;report id here&gt;', permissions: models.Permissions.Read, settings: { // filterPaneEnabled: false, // navContentPaneEnabled: true, background: models.BackgroundType.Transparent, panes:{ bookmarks: { visible: false }, fields: { expanded: false }, filters: { expanded: false, visible: false }, pageNavigation: { visible: true }, selection: { visible: false }, syncSlicers: { visible: false }, visualizations: { expanded: false } } } }; // Get a reference to the embedded report HTML element var $reportContainer = $('#reportContainer')[0]; // Embed the report and display it within the div container. var report = powerbi.embed($reportContainer, embedConfiguration); &lt;/script&gt;</LI-CODE><P>&nbsp;</P><P>&nbsp;</P> Sat, 22 Aug 2020 20:36:09 GMT https://community.fabric.microsoft.com/t5/Developer/Auto-Generate-Embed-Token-using-Javascript-and-PHP/m-p/1316556#M25399 Noobtastic_com 2020-08-22T20:36:09Z https://community.fabric.microsoft.com/t5/Developer/Auto-Generate-Embed-Token-using-Javascript-and-PHP/m-p/1317620#M25404 <P>I can't be the only one that has run into this.</P><P>I have seen the ones for creating a function but I can't seem to get that to work either.</P><P>Has anyone gotten this to work with PHP and javascript?</P><P>Maybe a different authentication method would be better? Not sure what other options there might be.</P> Sun, 23 Aug 2020 21:07:55 GMT https://community.fabric.microsoft.com/t5/Developer/Auto-Generate-Embed-Token-using-Javascript-and-PHP/m-p/1317620#M25404 Noobtastic_com 2020-08-23T21:07:55Z https://community.fabric.microsoft.com/t5/Developer/Auto-Generate-Embed-Token-using-Javascript-and-PHP/m-p/1325065#M25449 <P><FONT face="tahoma,arial,helvetica,sans-serif">Hi&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/216775">@Noobtastic_com</a>,</FONT></P> <P><FONT face="tahoma,arial,helvetica,sans-serif">AFAIK, power bi generates token API include token string, expired time. I think you need to do add some additional processes to store and check generated tokens and the expired time.&nbsp;</FONT></P> <P><FONT face="tahoma,arial,helvetica,sans-serif">For example: </FONT></P> <P><FONT face="tahoma,arial,helvetica,sans-serif">Add if statements to check the expired time and stored token codes into your script. </FONT><BR /><FONT face="tahoma,arial,helvetica,sans-serif">If tokens expired or did not exist, you can invoke power bi rest to generated new tokens and corresponding token lifecycles and stored to sessions.</FONT></P> <P><FONT face="tahoma,arial,helvetica,sans-serif">Regards,</FONT></P> <P><FONT face="tahoma,arial,helvetica,sans-serif">Xiaoxin Sheng</FONT></P> Wed, 26 Aug 2020 08:30:42 GMT https://community.fabric.microsoft.com/t5/Developer/Auto-Generate-Embed-Token-using-Javascript-and-PHP/m-p/1325065#M25449 Anonymous 2020-08-26T08:30:42Z https://community.fabric.microsoft.com/t5/Developer/Auto-Generate-Embed-Token-using-Javascript-and-PHP/m-p/1333656#M25499 <P>I got the answer over on Stack Overflow:&nbsp;<A href="https://stackoverflow.com/questions/63564271/how-to-auto-generate-embed-token-using-javascript-and-php/63649863#63649863" target="_blank">https://stackoverflow.com/questions/63564271/how-to-auto-generate-embed-token-using-javascript-and-php/63649863#63649863</A></P><P>For anyone else, below is the working code with the formatting that I used. It should be mostly plug and play after changing 5 values to those applicable to your report.</P><P>Note that I couldn't get it to work on localhost due errors that appeared to be related to an authentication issue between localhost and the PowerBI servers. It does work on the live site.</P><P>Feel free to make it your own. Hopefully it will work with very minimal changes required.</P><LI-CODE lang="php">&lt;script src="https://code.jquery.com/jquery-1.11.3.min.js"&gt;&lt;/script&gt; &lt;script src="./dist/powerbi.js"&gt;&lt;/script&gt; &lt;div id="reportContainer" style="height: 1400px; width: 1000px;"&gt;&lt;/div&gt; &lt;?php // All the values used below can be generated at https://app.powerbi.com/embedsetup/appownsdata /* Get oauth2 token using a POST request */ $curlPostToken = curl_init(); curl_setopt_array($curlPostToken, array( CURLOPT_URL =&gt; "https://login.windows.net/common/oauth2/token", CURLOPT_RETURNTRANSFER =&gt; true, CURLOPT_ENCODING =&gt; "", CURLOPT_MAXREDIRS =&gt; 10, CURLOPT_TIMEOUT =&gt; 30, CURLOPT_HTTP_VERSION =&gt; CURL_HTTP_VERSION_1_1, CURLOPT_CUSTOMREQUEST =&gt; "POST", CURLOPT_POSTFIELDS =&gt; array( grant_type =&gt; 'password', scope =&gt; 'openid', resource =&gt; 'https://analysis.windows.net/powerbi/api', // Make changes Start client_id =&gt; '#####################', // Registered App Application ID username =&gt; 'john.doe@yourdomain.com', // for example john.doe@yourdomain.com password =&gt; '#####################', // Azure password for above user // Make changes End ) )); $tokenResponse = curl_exec($curlPostToken); $tokenError = curl_error($curlPostToken); curl_close($curlPostToken); // decode result, and store the access_token in $embeddedToken variable: $tokenResult = json_decode($tokenResponse, true); $token = $tokenResult["access_token"]; $embeddedToken = "Bearer " . ' ' . $token; /* Use the token to get an embedded URL using a GET request */ $curlGetUrl = curl_init(); curl_setopt_array($curlGetUrl, array( // Make changes Start CURLOPT_URL =&gt; "https://api.powerbi.com/v1.0/myorg/groups/#####################/reports/", // Enter your Workspace ID, aka Group ID // Make changes End CURLOPT_RETURNTRANSFER =&gt; true, CURLOPT_ENCODING =&gt; "", CURLOPT_MAXREDIRS =&gt; 10, CURLOPT_TIMEOUT =&gt; 30, CURLOPT_HTTP_VERSION =&gt; CURL_HTTP_VERSION_1_1, CURLOPT_CUSTOMREQUEST =&gt; "GET", CURLOPT_HTTPHEADER =&gt; array( "Authorization: $embeddedToken", "Cache-Control: no-cache", ), )); $embedResponse = curl_exec($curlGetUrl); $embedError = curl_error($curlGetUrl); curl_close($$curlGetUrl); if ($embedError) { echo "cURL Error #:" . $embedError; } else { $embedResponse = json_decode($embedResponse, true); $embedUrl = $embedResponse['value'][0]['embedUrl']; // this is just taking the first value. you need logic to find the report you actually want to embed. This EmbedUrl needs to match the corresponding ReportId you later use in the JavaScript. } ?&gt; &lt;script&gt; // Get models. models contains enums that can be used. var models = window['powerbi-client'].models; // Embed configuration used to describe the what and how to embed. // This object is used when calling powerbi.embed. // This also includes settings and options such as filters. // You can find more information at https://github.com/Microsoft/PowerBI-JavaScript/wiki/Embed-Configuration-Details. var embedConfiguration= { type: 'report', // Make changes Start id: '#####################', // the report ID // Make changes End embedUrl: "&lt;?php echo $embedUrl ?&gt;", accessToken: "&lt;?php echo $token; ?&gt;", permissions: models.Permissions.Read, settings: { background: models.BackgroundType.Transparent, panes:{ bookmarks: { visible: false }, fields: { expanded: false }, filters: { expanded: false, visible: false }, pageNavigation: { visible: false }, selection: { visible: false }, syncSlicers: { visible: false }, visualizations: { expanded: false } } } }; var $reportContainer = $('#reportContainer'); var report = powerbi.embed($reportContainer.get(0), embedConfiguration); &lt;/script&gt;</LI-CODE><P>&nbsp;</P> Sat, 29 Aug 2020 17:33:04 GMT https://community.fabric.microsoft.com/t5/Developer/Auto-Generate-Embed-Token-using-Javascript-and-PHP/m-p/1333656#M25499 Noobtastic_com 2020-08-29T17:33:04Z