python
23 TopicsPower BI Report Server (September 2025) - Are Python Visuals Supported?
Hi all, I am using Power BI Report Server September 2025 (on-premises) but will upgrade to May 2026. I have a Power BI report that contains a Python visual. When opening the report, I receive the following error: "Python visuals are currently disabled in your organization." I found documentation describing the"R and Python visuals" tenant setting in the Power BI Service / Fabric Admin Portal, but Power BI Report Server does not have a corresponding tenant configuration. My questions: Are Python visuals officially supported in Power BI Report Server September 2025 (and May 2026)? If yes, where can they be enabled or configured on PBIRS? If not supported, is there any official Microsoft documentation that explicitly states this limitation? Has anyone successfully rendered Python visuals in PBIRS September 2025 (and May 2026)? I am specifically asking about Power BI Report Server (on-premises), not Power BI Service / Fabric. Thanks in advance for any clarification or official references.Solved94Views0likes4CommentsDAX standalone query execution using python
Hi, iwanted to execute DAX query through service principal in python standalone (vsCOde). but i got the error as below. Status Code: 401 {"error":{"code":"PowerBINotAuthorizedException","pbi.error":{"code":"PowerBINotAuthorizedException","parameters":{},"details":[],"exceptionCulprit":1}}}Solved1.4KViews0likes5CommentsDax Studio - Python Connection
Hello All, There is a plan to move data source from one database to another for which it would be essential for us to understand the dashboards within a workspace. I have explored few options in Dax Studio which has capability to return Measures, Columns, Catalogs (Dashboards) and other details of a specific workspace. However if I need to get a detailed inforamtion across all the Power BI Dashboards in a workspace, the commands below would not allow me to. SELECT [CATALOG_NAME] FROM $SYSTEM.DBSCHEMA_CATALOGS SELECT [CATALOG_NAME] FROM $SYSTEM.DBSCHEMA_CATALOGS, SELECT [ID],[Name] FROM $SYSTEM.TMSCHEMA_TABLES WHERE NOT [IsHidden] SELECT * FROM $SYSTEM.TMSCHEMA_COLUMNS WHERE NOT [IsHidden] SELECT [ID],[TableID],[Name],[QueryDefinition] FROM $SYSTEM.TMSCHEMA_PARTITIONS SELECT [ID],[TableID],[Name],[Expression] FROM $SYSTEM.TMSCHEMA_MEASURES WHERE NOT [IsHidden] SELECT * FROM $SYSTEM.TMSCHEMA_RELATIONSHIPS Requesting your guidance if there is a way I can loop through all the commands above and get the data into Excel format or into SQL or connect to Power BI directly so that I can analyze it further. Regards Mithun T1.2KViews0likes5Commentspython 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)? Thanks837Views0likes1CommentPython editor overhaul - PowerBI
PowerBI has big quality issues with the Python editor. I'm used to PyCharm/IDLE/the Python REPL, and found it very hard to diagnose Python scripts, interpret errors, or even make small changes to them in PowerBI. 1. When you go to "Get Data > More > Python Script", you are only allowed to paste a Python script in. You can't use a file on disk. PowerBI forces you to embed a static script in PowerBI. This is annoying because it'd be nice to maintain a file-based repo of Python scripts, instead of embedding them in the .pbix file. 2. If I want to edit the imported Python script, you get a terribly hard to read block of text: let Source = Python.Execute("import pandas as pd#(lf)#(lf)# Example data#(lf)data = {#(lf) 'Category': ['Electronics', 'Electronics', 'Furniture', 'Furniture', 'Office Supplies', 'Office Supplies'],#(lf) 'Sub-Category': ['Phones', 'Laptops', 'Chairs', 'Tables', 'Paper', 'Binders'],#(lf) 'Sales': [5000, 7000, 3000, 4000, 1000, 2000],#(lf) 'Profit': [1500, 2000, 500, 800, 200, 600],#(lf) 'Date': ['2024-01-01', '2024-02-01', '2024-01-01', '2024-02-01', '2024-01-01', '2024-02-01']#(lf)}#(lf)#(lf)# Create the DataFrame#(lf)df = pd.DataFrame(data)#(lf)#(lf)# Convert Date column to datetime#(lf)df['Date'] = pd.to_datetime(df['Date'])#(lf)#(lf)print(df)#(lf)"), df1 = Source{[Name="df"]}[Value] in df1 3. Error logs have no history: If I have a Python error, I can't easily diagnose it from within PowerBI or debug it. I have to open a separate text editor, hope that I saved my original Python script, run it in my own REPL, and also copy the error to an external text editor. 4. No stdout: If my script prints to stdout, I can't view it. I could go on, but I think the main point stands: Debugging or editing PowerBI Python scripts is really painful. Even an IDLE-like interface would be amazingly useful. Alternatively, a community guide on "How do I develop complex Python scripts within PowerBI and test them" would be useful. Perhaps Microsoft could make a Github repository that has a flow set up.Solved802Views0likes2CommentsWhat should not work in PBI-RS from data sources coming from python scripts?
Hello, is it true that python scripts are not supported in PBI RS? I created in PBI desktop for PBI-RS a report that retrieves data from an API consumed and processed using python scripts, I published it to the Report Server and tried to open the report, it worked well and the visuals are loaded as normal, so what are not supported about python scripts? The documentation says the following, but it is contra dictory to my tests: From the comparison between PBI Service and Server: Create Python scripts and visuals in Power BI Desktop and publish them to the Power BI service. You can't save Power BI reports with Python scripts or visuals to Power BI Report Server. Please clarify this topic for me, thanks in advanceSolved470Views0likes1CommentGroup by and count - How to translate this from python
Hi everyone, im new to powerbi DAX and im with a problem to solve... i have a table like this: COD_EVENT DEVICE_ID CITY DATE CAUSE 3002 134 CAMPINAS 01/02/2020 ELECTRICAL DISCHARGE 3005 147 CAMPINAS 02/10/2020 ANIMALS 4008 128 SAO PAULO 03/11/2020 WIND 4009 159 SAO PAULO 01/02/2021 ANIMALS 4013 128 SAO PAULO 02/05/2021 ELECTRICAL DISCHARGE 7892 178 CAMPINAS 01/11/2019 DEVICE FAIL ... ... ... ... i need to count from a date(m/y), for example dez/2020, the events in last 12 months, after this, i need groupby DEVICE, and show the quantity of events in devices that had more than one in last 12 months e the quantity of events in devices that had only one event in last 12 months. An example of what i expect to get: DATE CITY RECURRENT UNIQUE DEZ/2020 CAMPINAS 3 1 JAN/2020 CAMPINAS 3 2 FEV/2020 CAMPINAS 4 1 DEZ/2020 SAO PAULO 2 3 JAN/2020 SAO PAULO 2 4 FEV/2020 SAO PAULO 1 5 ... ... ... ... Where RECURRENT calculates the number of events in devices that had more than one event in the last 12 months since the date described in DATE, for the city described in CITY. And UNIQUE calculate de amount of events in devices that had only 1 event in last 12 months for that city. I make this work in python, and i did something like this: city = events_df['CITY'].unique() #Extract all cities present in dataframe tab_fin = pandas.DataFrame() #Create a df to append each iteration for i in range(0,len(city)): events_by_city = events_df[events_df['CITY'] == city[i]] #Create a table inside the loop that contains only the events of a especific city date_ini = pandas.to_datetime('2020-12-31') #first month of interest last_date = date.today().replace(day=1) - timedelta(days=1) #last month of interest num_months = (last_date.year - date_ini.year) * 12 + (last_date.month - date_ini.month) #number of dates between date_ini e last_date for j in range (0,num_months+1): events_12months = events_by_city[(events_by_city['DATE'] > date_ini + relativedelta(months=-12)) & (ocorr_conj['DT_INICIO'] <= data_ini)] #Extract the events in last 12 months events_grouped = events_12months.groupby('DEVICE_ID')['COD_EVENT'].count().reset_index() recurrent = sum(events_grouped[events_grouped['COD_EVENT']>1]['COD_EVENT']) #events in devices that had more than 1 unique = len(events_grouped[events_grouped['COD_EVENT']==1]) #events in devices that had only 1 tab_aux = pandas.DataFrame({'CITY':city[i], 'DATE':str(date_ini.month) +'/'+ str(date_ini.year), 'RECURRENT':recurrent, 'UNIQUE':unique}, index=[0]) tab_fin = tab_finappend(tab_aux) #Append in tab_fin the info of the i-city and j-month date_ini = date_ini + relativedelta(months=+1) #add 1 month to date679Views0likes1CommentOn-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.1.1KViews0likes2CommentsHow 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.Solved926Views0likes1Comment