Python Visual Support in Power Bi Report Server
Hi, I'm new to Power Bi Report Server(On-Premise). I wanted to know whether python visual is supported in Power Bi Report Server. I have created a sample python visual in Power Bi Desktop Optimized(September 2019). Just wanted to know if it will work on the report server. Thanks in advance. v-yulgu-msft v-evelk @v-danhe-msft @v-chuncz-msft @Greg_Deckler GuyInACube datanaut d_gosbellReport Server API pach datasource failing
Hi. We have a server with possibly hundreds of user created reports the need to have their connectionstrings updated. I've tried to get this to work using the API and a python script but without luck. Link to swaggerhub´s patch method. https://app.swaggerhub.com/apis/microsoft-rs/PBIRS/2.0#/PowerBIReports/UpdatePowerBIReportDataSource The 'get' method works fine but the 'patch' returns 400 Bad request. Has anybody been successful with this? Using this RS Version 1.5.7074.36177 (May 2019) code snippet import json import requests from requests_negotiate_sspi import HttpNegotiateAuth uri = 'http://localhost/Reports/api/v2.0/PowerBiReports(17872a26-8066-4a96-b149-c4f327f91daf)/DataSources' payload = {'ConnectionString': 'data source=GRAL-PROD-DB01,51491;initial catalog=IFD_Journal_AL;persist security info="false"'} headers = {'Content-type': 'application/json'} r = requests.patch(uri, auth=HttpNegotiateAuth(), json=payload, headers=headers) print(r.status_code) r = requests.get(uri, auth=HttpNegotiateAuth(), headers=headers) print(r.status_code) print(r.content) Here´s the response when run in sublime on windows 10. CMD.EXE was started with the above path as the current directory. UNC paths are not supported. Defaulting to Windows directory. 400 200 b'{\r\n "@odata.context":"http://localhost/Reports/api/v2.0/$metadata#DataSources","value":[\r\n {\r\n "Id":"1424c60b-0acb-e911-8346-648099cc70c1","Name":null,"Description":null,"Path":null,"Type":"DataSource","Hidden":false,"Size":0,"ModifiedBy":"VGREGION\\\\marst160","ModifiedDate":"2019-08-30T11:40:44.153+02:00","CreatedBy":"VGREGION\\\\marst160","CreatedDate":"2019-08-30T11:39:22.913+02:00","ParentFolderId":null,"IsFavorite":false,"Roles":[\r\n \r\n ],"ContentType":null,"Content":"","IsEnabled":true,"ConnectionString":"data source=xxxxxxxxxxxx;initial catalog=xxxxxxxxx;persist security info=False","DataSourceType":null,"IsOriginalConnectionStringExpressionBased":false,"IsConnectionStringOverridden":false,"CredentialRetrieval":"prompt","CredentialsByUser":null,"CredentialsInServer":null,"IsReference":false,"DataSourceSubType":"DataModel","DataModelDataSource":{\r\n "Type":"DirectQuery","Kind":"SQL","AuthType":"Windows","SupportedAuthTypes":[\r\n "Integrated","Windows","UsernamePassword"\r\n ],"Username":"marst160","Secret":"","ModelConnectionName":"de823fb1-b39a-4acd-9046-2e5f818e4794"\r\n }\r\n }\r\n ]\r\n}' Any help would be appreciated.How to use Python on top of a queried data table?
HI, I want to use Python on top of a via ODBC queried data table. What is neccessary for that? Install Python on the Report Server? On my local machine? Choose the interpreter? Is there a guide to follow? And how to set the link to the queried data? I guess Python is working with Pandas. Appreciate any helpOn-premises Power BI Report Server connect live to an on-premise python or analysis server
Currently, I'm publishing dashboards on the on-premises Power BI Report Server. via SQL Enterprise. Edition. is there an on-premise python or analysis server? so can i run advance analyses live from the Power BI Report Server dashboard.
python example for a REST API power bi report server request
Hello, please someone has a python example of how using the REST API and interacting with some dashboard inside Power BI Report server? (I mean write a code to refresh automatically a dashboard or something like that using python outside of POwer BI) It could work in a internal wnvironment (Virtual machine)? Thanks