Forum Discussion

MJ_2019's avatar
MJ_2019
New Member
7 years ago

Problems with "Get Data", via SQL Serve Analysis Service

I'm a student and beginner in Power BI who needs help.... when i try get data from analysis services directly and put the server name, an alert appears: "The server you are trying to connect to doesn't have any models or isn't allowed to access to them". 

I have already tried various procedures and ask for help from more experienced people, but I continue with the same warning. I have already seen the credentials, the server name (localhost and the name that appears in Analysis Service, with and without \MULTIDIMENSIONAL).

 

Can someone help me? 

 

Thank you

 

 

1 Reply

  • Stachu's avatar
    Stachu
    Community Champion

    can you connect to it using other software, e.g. via pivot in Excel? if it's in the Azure AS, could the firewall be blocking the access?