Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Shedule refresh Error

Hi all, 

I am searching for a solution since 2 weeks now and still can't understand the problem.

 

I am using a excel link from teams sharepoint for my Dashboard and a couple directQueries.

The excel file has been moved into another folder. I've changed the link already which works perfectly fine on my PC.

Also when uploading it to the app.powerbi it works properly.

The problem happens as soon as I refresh in app.powerbi or use the shedule refresh option.

2 of the KPI's don't show up anymore ("can't display visual") even tho they are imported.

I also checked every single credential 5x already.

Does anyone have a solution for this please?

7 Replies

  • aj1973's avatar
    aj1973
    Community Champion

    Hi Anonymous 

    It sounds more like a name or type of a column or the name of the sheet in the Excel file of has changed...Open Power Query and refresh each and every table, you should see where the problem coming from.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Already tried that, but it still didn't work

  • AbbasG's avatar
    AbbasG
    Memorable Member

    Anonymous can you share the screenshot of error message?

    • Anonymous's avatar
      Anonymous
      Not applicable

      This is the error I get

      • AbbasG's avatar
        AbbasG
        Memorable Member

        Please click on see details to display the error message that you are getting.  Also, share the message to possibly help you further.