cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Eric Regular Visitor
Regular Visitor

File{"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 connect the dataset to our Enterprise Gateway and schedule it to refresh becasue of the file path errors.  Here's the format of the data source link that PBI Service is looking for:

 

      File{"path":"\\\\server\\shared-resource\\folder\\file"}

 

 

The data source settings all look fine in the pbix desktop file.  Has anyone seen anything like this or have any idea how to fix it?  All the other datasets in the workspace refresh fine.

6 REPLIES 6
Super User
Super User

Re: File{"path":"\\\\server\\shared-resource\\folder\\file"} - Duplicate "\

Hi 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.

Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"


Power BI Blog
Eric Regular Visitor
Regular Visitor

Re: File{"path":"\\\\server\\shared-resource\\folder\\file"} - Duplicate "\

Gilbert, thanks for the reply.  I have not tried the parameter idea, I will explore it, thanks for the tip.

 

On your first thought, I'm not sure how to moidfy the source path once the file has been uploaded to the Service, can you tell me how to do that?  The report is pointing to the embedded dataset, which is where the data source errors must be.  I can't find away to modify the data source path within the uploaded dataset.

 

 

Eric Regular Visitor
Regular Visitor

Re: File{"path":"\\\\server\\shared-resource\\folder\\file"} - Duplicate "\

Thanks 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.  

Super User
Super User

Re: File{"path":"\\\\server\\shared-resource\\folder\\file"} - Duplicate "\

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?

Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"


Power BI Blog
Eric Regular Visitor
Regular Visitor

Re: File{"path":"\\\\server\\shared-resource\\folder\\file"} - Duplicate "\

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.

 

 

Super User
Super User

Re: File{"path":"\\\\server\\shared-resource\\folder\\file"} - Duplicate "\

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?

Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"


Power BI Blog

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 127 members 1,638 guests
Please welcome our newest community members: