Power BI file does not refresh on the service, even though it refreshes on the desktop

[EduardoSantos]

Hello all,

Recently I have been having a problem that I cannot figure out with a power bi file. 

• The file is reading different .csv files, in a server which has a gateway installed
• This file is refreshing successfully on the service
• When I download the .pbix from the service to my local desktop, I connect to the server with a VPN and all good
• I then upload this file to the service, without any modification, and still, it refreshes well on the service. Until here no problem!
• I change a connection in the data model from "one to many" to "many to many" and it refreshes well on the laptop 
• I upload to the service and it gives me an error related to credentials invalid (which happens to various tabels random, not the same every time)
• I download again the file, change the connection to its original state (one to many), doesn't refresh again on the service, although refreshing well on the laptop

Does anyone now what can possibly be going on? It's one of those problems that I don't really know what to do more.

[EduardoSantos · Accepted solution]

Ultimately, uninstalling and reinstalling the gateway solved the issue here.

I asked the assistance from microsoft why this could have happened, that told me the problem could be related to a specific service from the gateway not running or something similar, but I could not track the problem completely due to reinstalling the faulty gateway.

[v-lionel-msft]

Hi @EduardoSantos ,

According to the error message, it is clear that the credential of the data source is wrong. Please check the credential of this data source.

Best regards,
Lionel Chen

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

[EduardoSantos]

Hello @v-lionel-msft ,

Thank you for your assistance. Howeverer, credentials in this case are granted by the admin:

Also, I just changed the relationship from a table in the data model, which, to my knowledge, shouldn't change the credentials from the file working.

[Greg_Deckler]

Extremely difficult to troubleshoot. You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

[EduardoSantos]

@Greg_Deckler Thank you for your response!

I checked the issues forum, and there were some comments very similar to my problem:

https://community.powerbi.com/t5/Issues/Gateway-Refresh-Problem/idi-p/987088

Will open a ticket and then update.