Forum Discussion
emilycgather
4 years agoNew Member
Setting up a File data source using Gateway in a published report
I've just had such a problem setting this up and I wanted to post my solution here to see if anyone can confirm or deny what I think I'm seeing. Here's my scenario. Designing a report using an E...
Tutu_in_YYC
4 years agoSuper User
Hi,
If i read this correctly, you set up your report datasource using Path1 (c:\myfolder\myfile.xls), but once you published this to the service, you are trying to connect Path2 (\\servername\fileshare\myfile.xls) to the dataset through the gateway. Is that right? If yes, my guess is Path1 is still the one that is being used in the M query, and you cant edit the Path1 to Path2 through Power BI service.
Can you provide a screenshot of where you have the option to change the full path?