Dataflow Gen2 Web API Errors

[Anonymous]

Hi,

We're trying to fetch data from API (with gateway) using Fabric Dataflow Gen2 but faced some issues while trying.

First of all we tried directly connect to API with using base url and we're getting the error in the below. I believe main issue in here is we need to connect this API with body but there is no body section we can insert like in pipelines. 

As a second approach we tried to manually write power query code to fetch the data from api and we succeeded. We can fetch the data and see the data in the dataflow gen2 but when we try to publish the dataflow we're getting error.

Error after trying to publish the dataflow;

Any help ?

Thanks

[v-cboorla-msft]

Hi @Anonymous 

Thanks for using Microsoft Fabric Community.

Apologies for the inconvenience that you are facing here.

As I understand that you're facing an issue due to problems with data source credentials in Microsoft Fabric dataflow gen2 while connecting to a web API.

I tried to repro the same scenario but did not find any difficulty in accessing the data from Web API. Please find the screenshots for reference.

Could you please confirm how you are configuring the data source authentication kind? 

Try to connect using create new connection this might help you.

If the issue still persists please do let us know.

Hope this helps.

[v-cboorla-msft]

Hi @Anonymous 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.

Thanks

[v-cboorla-msft]

Hi @Anonymous 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others.
If you have any question relating to the current thread, please do let us know and we will try out best to help you.
In case if you have any other question on a different issue, we request you to open a new thread.

Thanks.