cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AlexSavchenko
Frequent Visitor

Issue after publishing dataset based on SSAS to Power BI Online

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

 

 

2 REPLIES 2
AlexSavchenko
Frequent Visitor

Any Ideas?

 

Today I have tried to replicate the same environment, but on local server, not in Asure.

Results the same,

I thought, that problem somewhere on the boarder between Azure VM and Web, but seems not...

 

Solved. The problem was, that PowerBI Pro users were not matched with SSAS Domain users

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.