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.
Are there plans to allow Excel workbooks that have been built using a live connection to a SSAS Tabular server and uploaded to the Power BI service via One Drive for Business to refresh in the same manner power view reports are allowed to live query SSAS tabular via the Analysis Services Connector while viewing the workbook through a browser via Excel Services?
If you have an Excel workbook with PowerView reports against an AS Tabular model, when publish this workbook to PowerBI (and if the AS server is accessible via the AS Connector) it will create a data set against that AS Model and it will add the PV reports from the Excel file in the reports section. The only thing that does not seem to work right now is the sheets that do not have PV content. so if you had a Sheet with Excel charts in it and pivot tables, those will not be rendered by the services today. My understanding is that eventually the service will render Excel content as well as PV content from the same workbook.
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.