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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Anonymous
Not applicable

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:

script code.PNG

 

---------
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) 

native query issue secured.PNG

 

 

 


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

 

[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]

configure connection button.PNG

 


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

2 REPLIES 2
v-easonf-msft
Community Support
Community Support

Hi , @Anonymous 

You can refer some related post here:

https://community.powerbi.com/t5/Service/Dataflows-message-quot-Please-specify-how-to-connect-quot-when/td-p/714325

https://community.powerbi.com/t5/Service/Dataflow-to-SAP-HANA-unable-to-connect-quot-Please-specify-how/m-p/605948

https://radacad.com/how-to-use-dataflow-to-make-the-refresh-of-power-bi-solution-faster

 

If it is still unsolved, please kindly raise it to the support team for better advice, thanks a lot!
https://powerbi.microsoft.com/en-us/support/ 

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

Thanks for the links i have tried to test through them:

https://community.powerbi.com/t5/Service/Dataflows-message-quot-Please-specify-how-to-connect-quot-w...
the individual here is experiencing similar issue as me but no solution has been provided

https://community.powerbi.com/t5/Service/Dataflow-to-SAP-HANA-unable-to-connect-quot-Please-specify-...
- Sap Hanna is a solution for finding on prem gateway - my data source is not on prem 


https://radacad.com/how-to-use-dataflow-to-make-the-refresh-of-power-bi-solution-faster

Rada has not provided a solution to my issue here. 

I have raised a query with support at the site you provided details to (thank you) :
https://powerbi.microsoft.com/en-us/support/ 
my support ticket incase any Microsoft Personality can assist: 120032522002537

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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