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.
Hi,
I have a rich and interactive excel workbook which is built against pivot tables fetching data from a multidimensional cube. I would like to now host this workbook online on office365 sharepoint. Is it possible to do so?
I was assuming it is and the way it would work is via the On-premises data gateway. Here was the workflow i intened to follow:
1) Connect the MD Cube data source to On-Premise data gateway
2) Build a new Power BI report and add the dataset
3) Use analyse in excel to get an instance of the report in excel
4) Build the pivot tables and publish the workbook to the o365 sharepoint site.
Would it work?
That should work. You can connect to on-premises Analysis Services (AS) databases using DirectQuery, and include data in reports created using Analyze in Excel. You must be on the same Active Directory domain as the AS database.
Please take a look at this document for details.
Best Regards,
Herbert
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.