cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jpayne Regular Visitor
Regular Visitor

Data Flows - not able to connect to APIs (web.content) or Cosmo DB...

I copied some M queries I have from a PBIX into flows and they could not be validated.

 

APIs failed on the anonymous authenticaion type which works in the PBIX (gateway needed?...). 

 

Cosmo DB failed because of "missing module" ... but the query wors in the desktop PBIX.

 

 

3 REPLIES 3
Community Support Team
Community Support Team

Re: Data Flows - not able to connect to APIs (web.content) or Cosmo DB...

Hi @jpayne,

Based on my test, it could work on my side:

1.PNG

Could you have tried to configured gateway for your datasource?

1.PNG

Regards,

Daniel He

 

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
jpayne Regular Visitor
Regular Visitor

Re: Data Flows - not able to connect to APIs (web.content) or Cosmo DB...

We shouldnt need a gateway, i dont think - our data is not On-Prem, it all comes from Cosmos DB (JSON) and APIs (web content).

 

Also, for the APIs we are using anonymous connection, with no token. It works in PBIX.

 

It does not work in PBIS or Data Flows.

 

Is it possible to make the protocols for API connetion in PBIS and Data Flows match those in PBIX - they work in PBIX,..

Community Support Team
Community Support Team

Re: Data Flows - not able to connect to APIs (web.content) or Cosmo DB...

Hi @jpayne ,

Based on my research, if you want to use the web as data source, you have to configure a gateway for your web:

https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh#on-premises-data-gateway

I have tested the authenticaion in dataflow, it seemed that I need to enter windows account, I suggest to have a try.

 

Regards,

Daniel He

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