Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

dataflow - connecting issue with azure analysis service - Configure Connection

I am trying to connect power bi dataflow to Azure Analysis Server. I have windows authentication.
I created the script (m query) in power bi desktop and tested it to run and refresh in power bi services - it works.

a simple script like this:

 

---------
I created a blank query in power bi dataflows and pasted the above script
The first issue i got [1]:
The evaluation was cancelled because it contained a native database query for the data source with kind "AnalysisServices" and path "asazure://northeurope.asazure.windows.net/XXXX;XX
Finance Model". Native queries may be unsafe and alter the database. Click Continue to allow all native queries to run.

(not a problem, clicking continue moves the process forward) 

 

 

 


[2]
once i click on the continue button i receive the following instruction:
Please specify how to connect.
a button is there: Configure Connection

 

[3]
next after clicking configure connection :

a pop up appears : enter credentials
I choose organisational account with my current sign in and click "Connect".

 
 

[4]
Next :
I am returned to the "Please specify how to connect" screen with the button "configure connection" - back to [2]

 


I am stuck in an endless loop.  Any idea on the issue I am facing?

2 Replies