Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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?
Hi , @Anonymous
You can refer some related post here:
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.
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
User | Count |
---|---|
46 | |
32 | |
30 | |
27 | |
25 |
User | Count |
---|---|
55 | |
55 | |
35 | |
33 | |
28 |