Good afternoon and happy new year.
I'm testing the Enterprise Gateway with a SSAS data source but I cannot visualize my report in PowerBI
These are the steps I followed:
1. I have installed the Enterprise Gateway on the same AS server.
2. The gateway is configured and a data source is added to it. The credential used has server administration rights on the SSAS Server and belongs to the Admin Role in my OLAP DB.
3. I have built a new report using Power BI Desktop (using the option "Explore live"). It works fine.
4. I have published the report successfully but I'm not able to open it in PowerBI: Report could not access the data source because you do not have access to your data source via an Enterprise Gateway
On top of that, when I try to open the Power BI Enterprise Gateway directly from Start I have an error message as well: 'Failed to contact gateway service"
What am I doing wrong?
I'm not sure if this is a clue: I don't have the same password for my AD account and my PowerBI account. Still, the user is the same:
companydomain\user (AD) and firstname.lastname@example.org (Power BI).
Thanks in advance 🙂
Had a similar problem, it helped to just delete all affected reports and connections on PowerBI.com and publish the same reports again. Guess its some problem related to the reports beeing on PowerBi.com over the course of an update.
I realize that this is for the Analysis Services connector but the same basic troubleshooting should apply:
First, make sure you have a Pro account.
Second most probable would be something to do with your firewalls and connectivity between the gateway and Power BI service.
The error does not point to credential issues, it sounds more like it can't see the gateway but it could be some sort of credential issue, that link above will explain how those credentials get translated.
I am facing the same issue here. Just wondering whether the threadstarter have managed to solve his issue? Is this issue caused by the need of opening outbound connections to the domain names and ports stated in the link below?
I face the same issue.
Tried with Firewall on/off. Explicitly enabled firewall rule outbound port 443. Same result.
Getting the same error message, the eneterprise gateway works fine with DirectQuery to the normal database but not when connecting to Analysis Services...
Check out the News & Announcements to learn more.
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Microsoft received the highest score of any vendor in both the strategy and current offering categories.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.