server reporting
12 TopicsHow to take an input string on Power Bi server that then would be passed to a Python script
Hi all, I have a Python script as my data source that that goes something like that: user_date = input() query = "select ... from... where date = '{}'".format(user_date) df = pd.read_sql(query, conn) print(df)" I want the user to enter the data on the Pwer Bi reporting server (or preferably choose from a drop down menu that has the last 30 days' dates) and then this date would be passed to the python script somehow so it'd run and query the correct data. Thank you.Solved922Views0likes1CommentRow level security - doesn't work for some people
Dear Colleagues, I created a row level security option on the power bi dashboard which is shared via power bi report server. It works for most of the people but I have the case when it doesn't work for some people (they are in the data source with valid ID used for row level security option). They can open dahsbard but it doesn't display data. Do you know what could be the reason? Thank you in advance! AsiaSolved1KViews0likes2CommentsConstant Line not Displaying in the Power BI Server
I created a bar chart on the Desktop and add a constant line in there. All good, but once I publish it on the server the constant line is missing. I believe it is a bug, somebody else with the same problem? In the Desktop: In the Server: Thank you1.2KViews0likes3CommentsDial Gauge Chart is vanishing in the published PowerBI report on server
Hi All, I am unable to see the Dial Gauge Charts in the published report on server. Was able to view them last week consistently. The charts seem to be there if I click on the area but are are not visible. Note: The charts are visible and active in the Desktop version of PowerBI. Appreciate any help on this. Thanks, Akshay1.6KViews4likes3CommentsAPI - Update Datasources not changing report data
Hi, I'm trying to use the "Datasets - Update Datasources In Group" API endpoint to remap the datasources of reports hosted on the Power BI server between different SQL Server databases. I submit the following JSON as part of the call: json_content = { "updateDetails": [ { "datasourceSelector": { "datasourceType": "Sql", "connectionDetails": { "server": "<current server>", "database": "<current DB>" } }, "connectionDetails": { "server": "<target server>", "database": "<target DB>" }, "datasourceId": "<target_datasource_ID>", "datasourceType": "Sql", "gatewayId": "<target_gateway_ID>" } ] } and when I check the datasource via the "Datasets - Get Datasources In Group" it seems to have remapped successfully. However, this doesn't seem to be reflected in the report data. I have tried refreshing the report both manually in the server UI and via the dataset refresh API endpoint. Is there something I'm missing in getting the datasource update to carry through to the report data? Thanks487Views0likes0CommentsPower BI Server fails to refresh, yet refresh's on Desktop
Hi, Me and my colleague have recently added a file to the PowerBI Server, It succesfully refreshes on PowerBI Desktop but the scheduled refresh has the following error: [0] -1055784932: Unspecified error. The exception was raised by the IDbCommand interface. [1] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface. [2] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface. [3] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface. [4] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface We think it's to do with the connection to the data sources which are on a shared drive, but we are unsure how. If anyone is able to give us a fix, that would be fantastic. Thankyou.1.1KViews0likes3CommentsWeb Service URL not working
Hello, I installed Power BI Report Server version 15.0.1102.759, which at the time of this of post is the latest version i downloaded, however the problem i am facing is the Web Portal URL is working fine, however the Web Service URL, is not, the Web Service URL i changed it from ReportServer to PBIRS, not sure if that made a difference or not, also the IP Address is "All Assigned", TCP Port 80, HTTP Cert not selected, also using an AD account. Any thoughts?Solved4.2KViews0likes2CommentsFeeding the same report with a new set of data on the PBI server
Dear Community, I have a .pbix file published to the server. The .pbix file is made in Power-BI desktop fed with MS Excel data, and uploaded to the server using REST APIs. So far, everything went well and I see my report properly on the server. Now, I want to update the same report but with a new dataset (the dataset is Excel and has the same columns and format). Do you know how this replacement of the data manually and eventually with APIs is possible? Thank you in advace, MajidSolved856Views0likes2Comments