Power BI connected LinkedIn Sales Navi app and show 500: Internal Server error on daily refresh

[Peter-HW]

Hello everyone,

I successfully connected the LinkedIn Sales Navigator Analytics Integration app with Power BI using the guide provided by Microsoft. While the connection works and is functional, I encounter a recurring issue during the daily refresh—it consistently shows a "500: Internal Server Error" along with the error message below.

After setting up the connection using the guide, it automatically generated the Power BI report and Semantic model. However, this refresh error prevents the LinkedIn Sales Navi data from staying updated, and I also have an internal report linked to the Semantic model that fails to retrieve data as a result. Sometimes, after refreshing the model a few times, the errors would mysteriously disappear. However, over the past three weeks, this approach has stopped working. I even tried deleting the report and semantic model to recreate everything from scratch, but the error message still reappears after a day.

Has anyone experienced a similar issue and found a way to ensure the daily refresh runs without errors? Please have the guide and error message below.

Article link: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-connect-linkedin-sales-navigator?wt....

Error message : 

Data source error: 500: Internal Server Error LIUUID : AAYvpoNdIm4To0DDq6bo8g==. https://api.linkedin.com/v2/salesAnalyticsExportJobs. . The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: Activity Outcomes.
Cluster URI: WABI-NORTH-EUROPE-I-PRIMARY-redirect.analysis.windows.net
Activity ID: 17378f8d-36cb-4416-a10d-06f101f929cb
Request ID: a5538cd7-1f69-4339-aeef-29d7dd29abaa
Time: 2025-03-06 06:21:16Z

Thank you.

Best regards,

Peter.

[v-nmadadi-msft]

Hi @Peter-HW  ,
Thanks for reaching out to the Microsoft fabric community forum.

Reconfirm that all fundamental requirements for a successful refresh have been met and verified: 

1) Check the Gateway Version: Ensure that the gateway is updated to the latest version. 

2) Confirm Gateway Selection: Verify that a gateway is selected for the report. If no gateway is assigned, the data source may have been modified or could be missing.

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS.
Thanks and Regards

[Peter-HW]

Thank you for the reply.

The gateway is configured by the LinkedIn Sales Navigator Analytics Integration app, with the default set to "Personal Cloud Connection." Wondering if this is the latest version and correctly assigned gateway.

[v-nmadadi-msft]

Hi @Peter-HW,
The connection type determines how data is accessed in Power BI. A Personal Cloud Connection supports only Import mode, while a Standard Data Gateway allows Import, DirectQuery, and Live Connection options, enabling real-time or scheduled data access from various sources. 

Please switch to standard data gateway if the data source is using Direct query or Live connection and check if you are still encountering the issue. 

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS.
Thanks and Regards

[Peter-HW]

Hi  v-nmadadi-msft,
Thank you for the response.

The Cloud Connection default is ''Personal Cloud Connection'', which standard data gateway are you suggest to connect?

Thank you.

Best regards,

Peter.

[v-nmadadi-msft]

Hi  @Peter-HW,

Please create a new connection and test your app with it.
You can refer to this guide for detailed instructions on how to proceed:
Connect to cloud data sources in the Power BI service - Power BI | Microsoft Learn

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS.
Thanks and Regards

[Peter-HW]

Hi @v-nmadadi-msft,
Thank you for the reply.

I changed the Cloud connections to Linkedin Sales Navi and Data source credentials is managed by Linkedin, but the refresh is till fail.

Data source error: 500: Internal Server Error LIUUID : AAYwI6cFLfWgweMwMKkjQQ==. https://api.linkedin.com/v2/salesAnalyticsExportJobs. . The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: Activities.
Cluster URI: WABI-NORTH-EUROPE-I-PRIMARY-redirect.analysis.windows.net
Activity ID: 85df3671-4bf7-4bfa-bd47-d820b957a652
Request ID: d6795e8c-197a-a813-dd40-fd08fe58879c
Time: 2025-03-12 11:39:05Z

Thank you.

Best regards,

Peter.

[v-nmadadi-msft · Accepted solution]

Hi @Peter-HW,
Sorry to know it didn’t help. Please consider reaching out to Microsoft Support. You can provide them with all the troubleshooting steps you've already taken, which will help them understand the issue better and provide a resolution. They might be able to identify something specific about your admin account setup or provide a solution that isn't immediately obvious. 
Below is the link to create Microsoft Support ticket:
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
You can also contact Linkedin sales navigator support: Connect to LinkedIn Sales Navigator in Power BI Desktop - Power BI | Microsoft Learn

Thank you

[Peter-HW]

Thank you, for the help and direction, I will contact them.