topic Re: Can't add Windows Authentication to Data Sources. in Report Server

Can't add Windows Authentication to Data Sources.

cannibaltuna — Mon, 26 Mar 2018 20:54:04 GMT

I have PBIRS on premises and no matter what I do I can't seem to get the data sources to work to allow for Windows Authentication. I get a red circle with a line though it when trying to make changes to the data share.

I'll add a data source (excel file to keep it simple) to a local share or on a share on another server, create the report in PBI, then upload it to RS but always receive the same error.

"Scheduled data refresh is unavailable for files not mapped to a network drive path."

Any ideas what I am doing wrong?

Re: Can't add Windows Authentication to Data Sources.

Anonymous — Tue, 27 Mar 2018 07:04:21 GMT

Hi cannibaltuna

You need to use an UNC path, e.g. \\servername\sharename\filename.

Re: Can't add Windows Authentication to Data Sources.

cannibaltuna — Thu, 29 Mar 2018 18:32:59 GMT

Thanks for the answer, though that leads me to another question. How to I make the file path use UNC instead of a network drive since I can't edit the paths in the data sources?

Re: Can't add Windows Authentication to Data Sources.

Anonymous — Fri, 30 Mar 2018 06:15:41 GMT

Hi cannibaltuna,

You should open your report in PBI Desktop, change the path in Data source settings (home tab->edit queries->data source settings) and save the report back to the server.

Re: Can't add Windows Authentication to Data Sources.

cannibaltuna — Fri, 30 Mar 2018 15:50:54 GMT

Thank you for your help, I will give that a try.