Forum Discussion
Eric
Advocate I
7 years agoFile{"path":"\\\\server\\shared-resource\\folder\\file"} - Duplicate "\"
Power BI Service is duplicating the "\" in the UNC path for all of the data sources in one of my Power BI report. It refreshes fine in PBI Desktop but when I publish to Service I can't connec...
GilbertQ
Super User
7 years agoHi there, that should work.
Have you tried to modify the source path and remove the "\" once it has been uploaded to the Power BI Service and see if that works?
You could possibly create a parameter for your source, so that you can change it in the Power BI Service once it has been uploaded.
Have you tried to modify the source path and remove the "\" once it has been uploaded to the Power BI Service and see if that works?
You could possibly create a parameter for your source, so that you can change it in the Power BI Service once it has been uploaded.
Eric
Advocate I
7 years agoThanks for the parameters idea, I tried it on several of the data sources in the report but the result is still the same in the service.
- GilbertQ7 years ago
Super User
That is really unusual as I would expect it to work.
What if you had to create a mapped drive on your Gateway Server, which could then use the UNC path?- Eric7 years ago
Advocate I
Thanks for the idea Gilbert but we tried that too and it didn't work either.
We have 31 data files in that directory and the only way we can connect the dataset to the gateway is if we add each individual file as a data source. We cannot simply reference the Folder, it won't work. Very strange since it works in other datasets but it will not work in this one and the other datasets share many of the same queries.
- GilbertQ7 years ago
Super User
Hi there
Are all the files in one folder?
If so, what if you had to use the Folder Option instead of the 31 individual files?