Sharepoint List integration with Powerbi (Status Code 500)

[Lama1234]

I have a sharepoint list with lookup columns, calculated columns. i am trying to integrate this list to visualize in powerbi, however i am getting the following error after waiting for sometime. Any help will be appreciated.

Activity ID: 2549c05b-485e-4b08-979d-a2664de0a099

Request ID: 0dc207c0-dfe2-8697-4ebb-a27e868f2e6a

Correlation ID: 41072e8a-cb6f-db30-53e7-fe2511e414a4

Status code: 500

Time: Wed Mar 29 2023 10:15:55 GMT+0900 (Japan Standard Time)

Service version: 13.0.20342.55

Client version: 2303.3.12949-train

Cluster URI: https://wabi-us-north-central-g-primary-redirect.analysis.windows.net/

[v-xiaoyan-msft]

Hi  @Lama1234 ,

Would you mind describing the problem in a little more detail. What specific scenario does it occur in? Are you unable to open this report or are you able to open it but unable to interact with it?
Also in addition to the error code below is there an error message, it is usually a statement under summary.

Best regards.
Community Support Team_ Caitlyn

[Lama1234]

Caitlyn, Thanks for the response. Please refer to screenshots...

[Lama1234]

i dont know what happened but this is error is resolved. I can now integrate and visualize in Power bi.