Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
ChristianDGreat
Resolver I
Resolver I

Azure Analysis Services Connection to Dataflow or Datamart

Hi,

 

So for some reason I cant connect to Analysis Services when I'm connecting via dataflow or datamart.

As of now when I'm in the company building I can connect via "Power BI Desktop" to the Analysis Services.

 

Also I published report and use a gateway the team setup for me.

 

The issue I have is I want to create bunch of Dataflow so I can massage the data so user outside the building can still use the data.

Specially working from home.

 

Here are the steps I'm doing let me know if im missing anything or I need to talk to our IT team for a privilage setup or something.

 

So I go to the Workspace > New > Dataflow

Then I select

ChristianDGreat_0-1659463827377.png

 

Then input the credentials

ChristianDGreat_1-1659463917503.png

When i click next i get this error :

ChristianDGreat_2-1659463972471.png

 

What does this mean? I google the error but I dont get any luck finding a solution.

 

Thanks

Chris

 

 

 

3 REPLIES 3
v-luwang-msft
Community Support
Community Support

Hi @ChristianDGreat ,

My first thought is as to whether or not you have updated the gateway.  I know that a lot of folks have had to recently update their gateway as they have gotten stale and the newer gateways have more capability and some more functionality.

 

And you could refer the below article ,and check if it is helpful :

Create Azure Analysis Services Dataflows on PowerBI.com 

https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-connect-pbi 

 

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien

Yup my gateway is up to date and still getting this error.
They also make me a system admin of the Analysis Services and still getting this error.

ChristianDGreat
Resolver I
Resolver I

Anyone?

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.