apis and embedding
66 TopicsMobile view is not being shown for embedded powerbi report
We have created a PowerBI report having both the desktop verion and mobile virson. Its showing desktop and pone view properly when we are testing at following sample site after putting correct information. https://microsoft.github.io/PowerBI-JavaScript/demo/v2-demo/index.html But when we open the website on mobile It is still showing the desktop version of the report. File version used of powerbi.js file is 'powerbi-client v2.5.1'. The HTML and javascript used is provided below We are also appending '&isMobile=true' with embed report url. Are we missing any reference to show the mobile version. <div id="reportContainer" style="width: 100%; height: 610px" aria-atomic="True" aria-multiline="True" aria-multiselectable="True" aria-orientation="vertical"> </div> <script src="~/Scripts/powerbi.js"></script> <script src="https://code.jquery.com/jquery-3.2.1.min.js"></script> <script> $(document).ready(function() { var txtAccessToken = "@Model.EmbedToken.Token"; var txtEmbedUrl = "@Html.Raw(Model.EmbedUrl)"; var txtEmbedReportId = "@Model.Id"; var tokenType = $('input:radio[name=tokenType]:checked').val(); var models = window['powerbi-client'].models; var permissions = models.Permissions.All; var config = { type: 'report', tokenType: tokenType == '0' ? models.TokenType.Aad : models.TokenType.Embed, accessToken: txtAccessToken, embedUrl: txtEmbedUrl, id: txtEmbedReportId, permissions: permissions, settings: { layoutType: models.LayoutType.MobilePortrait } }; // Get a reference to the embedded report HTML element var embedContainer = $('#reportContainer')[0]; var report = powerbi.embed(embedContainer, config); report.off("loaded"); // Report.on will add an event handler which prints to Log window. report.on("loaded", function() { Log.logText("Loaded"); }); report.on("error", function(event) { Log.log(event.detail); report.off("error"); }); report.off("saved"); report.on("saved", function(event) { Log.log(event.detail); if (event.detail.saveAs) { Log.logText('In order to interact with the new report, create a new token and load the new report'); } }); }); </script>Solved20KViews0likes8CommentsPower BI Rest API Internal Server Error 500
Hi, Power BI REST API is failing with 500 Internal Server Error from Apiary This is the API Add Rows: POST https://api.powerbi.com/v1.0/myorg/groups/{group_id}/datasets/{dataset_id}/tables/{table_name}/rows And this is the response 500 HEADERS connection:keep-alive cache-control:no-store, must-revalidate, no-cache transfer-encoding:chunked content-type:application/json; charset=utf-8 server:Microsoft-HTTPAPI/2.0,Microsoft-HTTPAPI/2.0 Microsoft-HTTPAPI/2.0 strict-transport-security:max-age=31536000; includeSubDomains x-frame-options:deny x-content-type-options:nosniff requestid:4e06760a-222d-47d6-9ccc-a97f98de2c32 date:Mon, 15 May 2017 19:54:18 GMT x-newrelic-app-data:PxQDVFVRCQITVlZRDgcFV0YdFGQHBDcQUQxLA1tMXV1dSnwZQRNWERdcRE42LGtnH0tLQBsBGVZXBBoCTF9UWwVWD1oJChgfAkkbVFMHVwNSDwcHUQUPVghGTQRWXUQDOQ== via:1.1 vegur BODY { "error": { "code": "GeneralException", "message": "Failed to process dataset PostRows", "target": "PostRows", "details": [ { "message": "SQL row count query failed: Database unreadable Server: tcp:dfmsitwcussql.database.windows.net, Database: DF-MSIT-SCUS-RestaUserDataStore-0, Command: SQLText" } ] } } Is this global issue? Please investigate. Thanks, -MinsukSolved16KViews1like6CommentsIssue with Drill-Through URL clickable when expression says Nothing
Please help! The logic was working perfectly fine, until last week update on service then the nothing became clickable: our loic is if payment amount is blank we use nothing to disable the click to drill-through and if it has a dollar amount we construct a url and the drill-through gets enabled. New behavior that broke our production reports is the when URL is Nothing became clickable and it take users to this url https://paginated-reports.powerbi.com/# Please help as this is affecting our client in embedded capacity. Thanks, J657Views1like1CommentAPI activePage.getFilters() throws 500 after drill through from a page with bookmark applied.
We have a report page with bookmark applied. After clicking an item to drill through to, the embed drills through successfully. However I am trying to get the current filters/visuals from the active page during the 'rendered' event. I have found that if I have the settings like this: settings: { panes: { filters: { visible: true, expanded: true }, } } The activePage.getFilters works as expected. However when visible is false. I can debug to a 500 from PBIs api request. If their is no bookmark state applied, it does not 500. I wonder if it has to do with a filter that is within the bookmark state. When the filters are visible, I noticed this filter in the result of getFilters, that stood out to me: { "$schema": "http://powerbi.com/product/schema#notSupported", "target": null, "filterType": 2, "message": "Not supported filter type - can't serialize to json syntax.", "notSupportedTypeName": "Passthrough" } I wonder if this is some how breaking the non-visible getFilters call? This was all reproducable in the PBI Playground. From a developer POV, the visibility of filters pane should not determine the result of the getFilters API call.Solved896Views1like1CommentAutomation of exporting power bi report to a shared drive path
Hi, I have a requirement for automatically without user interaction exporting and saving a powerbi paginated report to a shafed drive path. For this, i performed all these steps, i am using powerbi SDK in my C# consile application which is using three Api calls ExportToFileInGroup(), ExportToFileStatusInGroup(), GetFileOfExportToFileInGroup(). I have created a service principal with Tenant.Read.All application permissions and other delegated permissions too. I have added the service principal in a security group and enabled api authentication in power bi tenant settings. Added service principal as a admin in workspace. Workspace is of premium capacity. Issue: when i am calling ExportToFileInGroup(), it is returning a Export object with status 'NotStarted' but in next line when i am asking for ExportToFileStatusInGroup(), it is giving 'Failed' status without any runtime error. Please help me with this issue if you have any solution. Thanks.823Views0likes2CommentsPowerbi Usage powershell scripts failed
Dear All, I was running this below mentioned powershell scripts for the last 8 months but last 5 days i am getting error and the scripts are not running and getting the error. Please help. $connectsplat = @{ Certificatefilepath = 'C:\Windows\system32\Exocert.pfx' Certificatepassword = $(ConvertTo-SecureString -String "abc" -AsPlainText -Force) Appid = '123' Organization = "abc.ONMICROSOFT.COM" } Connect-ExchangeOnline @connectsplat Search-UnifiedAuditLog -StartDate (Get-Date).AddDays(-180) -EndDate (Get-Date) -RecordType PowerBIaudit -ResultSize 5000 | ConvertTo-Csv | Out-File C:\FinalDeployment\Powerbiusage\PowerBIAuditLog.csv error : "Write-ErrorMessage : One or more errors occurred. At C:\Users\s.muthu\AppData\Local\Temp\7\tmpEXO_2krypd2t.zsm\tmpEXO_2krypd2t.zsm.psm1:1120 char:13 + Write-ErrorMessage $ErrorObject + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:) [Search-UnifiedAuditLog], Exception + FullyQualifiedErrorId : [Server=DX1P273MB0490,RequestId=b2812735-eb75-c183-aba7-29b9b590442e,TimeStamp=Mon, 22 May 2023 09:17:19 GMT],Write-ErrorMessage"729Views0likes1CommentHow to add power bi reports into my personal erp software
hi experts, iam new to power bi, we are planning to move from other bi tool to power bi. but i have one doubt in that how can i see my dashboards into my erp software please help me(any services i want to add) thanks in advance4.6KViews0likes4CommentsPopulate Power BI tooltips and column descriptions from OData Feed?
Cross posting from Developer forum, maybe I could get someone to look at it here? Can you populate column descriptions and table tooltips information in Power BI via the Odata service document? E.g. using Core.Description Annotation terms? There seems to be something available for Common Data Model/Manifest model.json/manifest.json files as pbi:mappingDisplayHint but is there anything for odata?Solved760Views0likes2CommentsHide Custom Filters from Filters Pane
Hello Is there a way to hide the custom filter added in Power BI Embedded in iframe? I have added a custom filter like this. var filter = new models.BasicFilter({ table: "USERS", column: "Role" }, "Manager", [""]); The Filters pane has other filters that were created while creating this report.I want to hide this filter alone in Filters pane. Please guide me how I can achieve this. Thanks!3.9KViews0likes5Comments