topic Re: On Permises Gateway credentials issue in Report Server

On Permises Gateway credentials issue

Zaibass81 — Wed, 07 Jul 2021 09:57:41 GMT

Hi all,

I am trying to set up an on-premises data gateway, however, stuck with the credentials issue.

It all works fine with the personal gateway.

When I am trying to add the data source (Located on the mapped network drive) to the gateway it's asking for windows credentials (Not sure why but .. ) after providing the credentials it throws an error. From the error, it seems that it can't access the file source from the mapped network drive. Also tried to use the same credentials as would use to map that drive and still the same error.

Please advise.

P.S. I am new to the Power BI

Re: On Permises Gateway credentials issue

AbhiSSRS — Thu, 08 Jul 2021 06:19:14 GMT

You do need to key in credentials for accessing that source. These may be same as which you use on your dataset in Power BI report while creating that. Use fully qualified (with domain) in windows creds. Also check if taht ID is present on Users tab

Re: On Permises Gateway credentials issue

v-deddai1-msft — Fri, 09 Jul 2021 06:42:16 GMT

Hi Zaibass81 ,

Would you please try to use unc path for a network drive instead of using the drive letter. It should start with your servername. Please refer to https://stackoverflow.com/questions/21482825/find-unc-path-of-a-network-drive to get the unc path.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

Re: On Permises Gateway credentials issue

Zaibass81 — Fri, 09 Jul 2021 07:53:11 GMT

Hi @Dedmon Dai,

Yes, this should work. After doing some research and testing found that once the source location changed in the pbix file with full unc path did the trick...