Hi! I am trying to configure Power BI to use SSAS datasource, located on Asure VM.
It is my first experience with PBI, hope somebody can help to solve my problems.
Thanks in advance.
What I have now:
-Azure VM + SQL Server+SSAS, Default Azure Active Directory "xxx.onmicrosoft.com"
-Other Azure VM works at the same virtual network as Domain controller
-Service account of SSAS is a Domain User with all previleges
-Firewall temporary turned off
-ports that SSAS needs (outbound endpoints) opened on Azure (but not sure that they configured properly)
-Gateway installed and configured at the same machine as SQL + SSAS for the user who is Global admin of "xxx.onmicrosoft.com"
-Both datasourses created (for SQL and for SSAS) and tested successfully
-Local Domain and Azure AD ("xxx.onmicrosoft.com") synchronised by "Azure AD Connect" tool
-Simple Reports created in Power BI Desktop. One for SQL datasource, one for SSAS datasource. Both published with no Errrors.
As result:
I see names of both reports in the list in PowerBI Online.
But! SQL Report shows the picture properly, when
SSAS based report shows "Data source access error. Contact Gateway Admin" in the pink area at the top.
And "An unexpected error occurres" at the place where visual report have to be. Technical details do not discribe the reason. Simply Activity ID, Time, Version, URL
