Shedule refresh Error

[Anonymous]

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?

[AbbasG]

@Anonymous can you share the screenshot of error message?

[Anonymous]

This is the error I get

[AbbasG]

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

[aj1973]

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]

Already tried that, but it still didn't work

[aj1973]

did you check here?

[Anonymous]

Yes I've checked it several times there