Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
omar80005555
New Member

On-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.

 

 

 

 

 

2 REPLIES 2
josef78
Memorable Member
Memorable Member

Yes, from PBI Reports (pbix) and Paginated reports (rdlx), on Power BI Report Server you can connect live to dedicated instance of SSAS (to both, tabular models and also OLAP(multidimensional) models).

jpricket
Regular Visitor

Several different use cases here. 

 

1. You can easily integrate python and/or R in your Power BI Desktop files. However... if they are saved on a Power Bi Report Server, you cannot run scheduled refreshes. It is a limitation currently in the Report Server version. You could likely put together some API calls to the Report Server to do some download-->Refresh-->Redeploy scenario, but it might be easier to do this update manually depending on refresh rates required.

 

2. For advanced analytics, I would look at DAX expressions, these can be incoporated into PBIRS desktop files and easily support scheduled refreshes. Not the flexibility you get with Python or R, but still has some promising capabilities. If you want to take this a step further and have common data sources (Highly recomended for a large user community), you should look into creating tabular data models using a tool like SQL Server Data Tools. 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.