Forum Discussion
Refresh -
My guess is that the problem is based on the "Address" used in the Power BI file. Even though both of you have access to the file, he might not have access using the address you put into the file. The address that you have shared with your college is probably not the same as the address you have used in your file.
I'd attempt changing the address, do a close and apply. Publish back into the service and see.
When i originally did get data, I picked folder from the list, which brings in every excel file in the folder and basically appends them.
Ok , I understand the mistake. You picked Folder because the sheets are saved in your machine.
In the service, the refresh might work for you when you initiate it but never for your colleagues. The refresh can work for you because you might be using the Personal Gateway that you installed in your machine, and the personal Gateway can not be shared with others.
I recommend that you upload the files in a Folder in Sharepoint or in One Drive for Business then reconnect you report through Sharepoint Folder connector. This way you won't need a Gateway and your colleagues can do the refresh manually.
Thats the problem, I have them stored on one drive, but I guess the address is still pointing to me. Let me check the sharepoint folder connector vs. web.