Unable to connect to Dataflow from PowerBI Desktop through Getdata

[aravindh10]

Hi,

I am trying to getdata from PowerBI Dataflow. In Desktop, while connecting it asks for signin,for connecting to aadg.windows.net.nsatc.net and signing-in is not successful as in the screenshot, eventhough it is premium account

Pls suggest me a solution without using azure data lake

  

[v-lionel-msft]

Hi @aravindh10 ,

Maybe you can refer to the links.

Overview of single sign-on (SSO) for gateways in Power BI 

Azure AD Single Sign-On Basic Auth Popup 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[aravindh10]

Hi @v-lionel-msft 

Thank you for you relpy!!!

I have a sample MS Excel as source in Onedrive and created dataflow with that. Then, I try to getdata from that dataflow in Desktop ,it asks for the signin and If I enter the credentials , it shows the error as in screenshot.

And I have rectified the windows security signin thing and then also, issue persists.

Thank you.

[Melvlee]

Hi @aravindh10 ,

You can try to create a dataflow in Power BI service to replicate your excel solution and then use the dataflow as your source in PBI desktop.

If it answers your question, please give me a kudo.

Thanks and regards.