Forum Discussion
Power BI Enterprise Gateway for SSAS Multidimensional cube
Hi,
I tried creating report using multidimensional cube through Enterprise gateway, I can able to create report but few findings which we need to rectify
1. When I add a dimension column in the report filter, I cant able to see all the values in drop down.
2. My values are in billions, data range in y-axis are displayed as (0bn, 0.2bn, 0.4bn, 0.6000000000000001 bn ) but when i clicked the focus mode in the chart i can able to see the values correctly. It is looking odd in my dashboard.
3. Tiles in the Dashboard are not refreshing . Showing a warning message 'The Latest data cannot be displayed' but the report are showing live data . Is this work under progress? Or me alone facing this issue.
4. Text box is disabled in PowerBI Desktop but I can able to insert it after publish the report.
2 Replies
- BjoernContinued Contributor
Hi Arun,
I am afraid that AS Multidimensional live connection does not work with the Power BI WebService. Thus I think you do not need the gateway, i.e. you can not use it with MD.
BR
Bjoern
- Arun_taMicrosoft Employee
Hi Bjoern,
The below documention help us to install Enterprise gateway and create datasource for MD. If we create a report using PowerBI Desktop with live connection to MD and then publish the report. It will automatically use the Enterprise gateway.
https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-enterprise-manage-ssas/