LinkedIn ADs data via API

[Nikhil_Tailor]

Hello Community,

I am trying to get the performance data from the LinkedIn ADs center via their provided APIs. I have built an app on the developer platform, got it authorized from the admins and got access to ad accounts. I have created the token and got read access for the Advertisement API.

Now, I am wiriting the following function for getting my data in Power Query.

and I am writing the same in the postman client and there it is working.
But in power query it is giving me the following error

please tell me what am I doing wrong here or how can remove the error?
and get my data imported in the model??

[v-prasare]

We are following up once again regarding your query. Could you please confirm if the issue has been resolved through the support ticket with Microsoft?
If the issue has been resolved, we kindly request you to share the resolution or key insights here to help others in the community. Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.

Thank you for your understanding and participation.

[v-prasare]

If this issue geting you blocked, please consider raising a support ticket for further assistance.
To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

[v-prasare]

Hi @Nikhil_Tailor ,

if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.

Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support

[Nikhil_Tailor]

I have done all the steps in LinkedIn to complete all the authentication steps. But I am still getting the same error while connecting to the source. And I also cannot connect with the third-party connectors due to restriction.

[v-prasare]

Hi @Nikhil_Tailor,

LinkedIn APIs rely on OAuth 2.0 authentication, which isn’t natively handled by the standard Web connector in Power Query. As per Microsoft documentation, OAuth flows typically require implementation through a custom data connector, and only limited header handling is available outside that context. This can lead to scenarios where API calls succeed in Postman but fail in Power Query due to authentication and security handling differences. pleasetake a look at below references aand let me know if this helps?

Handling authentication for Power Query connectors - Power Query | Microsoft Learn

Solved: How to get Linkedin data into Power BI - Microsoft Fabric Community

Thanks,

Prashanth

[lbendlin]

Can you show the same details from the Postman call?  Error 500 usually means the server tripped over itself while trying to service your request.

[Nikhil_Tailor]

Hi Ibendlin
Sure, This is how I am using Postman to test the API