PowerBI connector to refresh error

[pang22]

Hello,

When I used the PowerBI connector to refresh data, it appeared below error.

How to solve it?

[v-kaiyue-msft]

Hi @pang22 ,

Error code 500 usually indicates a problem on the server side. Here are a few steps you can take to try to fix it:

1. First make sure you are using the correct and accessible API endpoint. Sometimes the server may be down or having problems. This error can sometimes be short-lived. Please try refreshing the data again after a few minutes.

2. Please check the data source credentials to ensure that they are correct and not expired.

3. If a large amount of data is being extracted, please try reducing the data load to see if that helps. Sometimes large data sets can cause the server to time out.

Best Regards,

Clara Gong

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

[pang22]

@v-kaiyue-msft For the third, point, I reduce the data load and extract but it only have 3000 lines data and the previous data disappear. Originally has over 27K records.

[rajendraongole1]

Hi @pang22 - refer below solved and links:

Solved: Solarwinds - data connection - Microsoft Fabric Community

https://www.youtube.com/watch?v=s8Rg-yUOJ-8

https://thwack.solarwinds.com/t5/NPM-Discussions/Solarwinds-and-PowerBi-Dashboard/m-p/201761

https://thwack.solarwinds.com/t5/NPM-Discussions/Making-a-Connection-to-Solarwinds-from-POWER-BI/m-p...

[pang22]

@rajendraongole1 I tried to reconnect and refresh the data but still have the same error. It can refresh successfully before.