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.
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.
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).
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
6 | |
4 | |
3 | |
3 |
User | Count |
---|---|
15 | |
9 | |
6 | |
3 | |
3 |