User Profile
abernal
Frequent Visitor
Joined 10 years ago
User Widgets
Contributions
Update Datasources REST API operation for live connections
I am trying to update the connection string of a live connection power bi report published to the service. In order to do so, I am using the "Update Datasources In Group" datasets operation of the REST API. I'm getting an "InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-RestMethod], WebException" in the response. Is is possible to change connection strings of published Power BI reports in live connection mode? Below is what I am trying to do and the response that I am getting... Thanks, Request $body = @" { "updateDetails":[ { "connectionDetails": { "server": "$($targetServer)", "database": "$($targetDatabase)" }, "datasourceSelector": { "datasourceType": "$($datasourceType)", "connectionDetails": { "server": "$($originalServer)", "database": "$($originalDatabase)" } } } ] } "@ $uri = "https://api.powerbi.com/v1.0/$groupsPath/datasets/$datasetID/Default.UpdateDatasources" Invoke-RestMethod -Uri $uri -Headers $authHeader -Method POST -Body $body Response Invoke-RestMethod : The remote server returned an error: (400) Bad Request. At H:\Projects\User Story 7483 - Infrastructure-Automated deployment of Power BI reports\20181003 Attempt\Change MOR Financial Report - Prod Orig to QA - Rest API.ps1:105 char:1 + Invoke-RestMethod -Uri $uri -Headers $authHeader -Method POST -Body $ ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-RestMethod], WebException + FullyQualifiedErrorId : WebCmdletWebResponseException,Microsoft.PowerShell.Commands.InvokeRestMethodCommandRe: Data gateway mode required to refresh an Excel workbook in Power BI with a Power Pivot data model
Thank you Lydia. I got it to work with an Excel workbook that contains a Power Pivot model that connects to an on-premises SQL Server database. I did not work, however, if the Power Pivot model connects to an Analysis Services Tabular database. I checked all the configurations and I am pretty sure that they are correct. Could you please perform the same test that you did before, but having instead a Power Pivot model that connects to an Analysis Services Tabular database? By the way, our Analysis Services Tabular database server is 2012. Below as some screenshots of my settings screens: 1) on-prem data gateway appears online for power pviot models that have a SQL Server connection... 2) on-prem data gateway appears offline for power pviot models that have a Analysis Services tabular connection... Thank you in advance for your assistance, AlexData gateway mode required to refresh an Excel workbook in Power BI with a Power Pivot data model
I have an Excel workbook uploaded to the Power BI service under the workbooks tab that has a Power Pivot data model which connects to an on-premises SQL server database. I have been able to successfully refresh the underlying Power Pivot data model with the data gateway on personal mode. Can I use the enterprise/standard mode of the data gateway to refresh the underlying Power Pivot data model of an Excel workbook? If so, how? Thanks, AlexRe: Multi-row Card formats oddly when "else" string value entered for all measures in the
Hi Herbert, I believe the multi-row control can no longer display text measures gracefully with the latest update of power bi desktop (2.48.4792.721 32-bit (July, 2017)). Below are two examples, one created with version Example 2.48.4792.481 32-bit (July, 2017) and another with Example 2.48.4792.721 32-bit (July, 2017). I have included a onedrive folder location, where with the images and a sample pbix file. This issue seems to appear when there are only measures selected. In some cases, when you add an attribute to the card, it seems to correct itself. For sample pbix image, you may go to https://1drv.ms/f/s!AhYq-Kv7shsJghopF6JRBZXdSEa7 We would appreciate if you can correct this issue as soon as possible. Thanks, Alex
