Published Report Can't connect to CSV file on network share

[Anonymous]

Hi,

I have a published Power BI Report that has a SQL Connect and 3 CSV's and and 1 XLSX.

All CSV and XLSX files are auto generated from an internal application and placed on the file share nightly.

When I refresh this report within Power BI Desktop, it works fine and is able to import the data.

When I publish to the report server and go to the data source of the report and enter in the credentials, I get the following error.

Couldn't connect

The report server couldn't connect to the data source using the information you entered. Make sure you've entered the connection string and any credentials correctly.

Could not find file '\\server01\folder1\name of file.xlsx'.

I even reverted back to my username and password as I know that works and I still get this error. Can someone assist. I have tried in the username, just the Username and also Domain\Username

[luisrh · Accepted solution]

your issue here is more than likely that the service account running PBI Report Server doesn't have access to the share. When refreshing from the service,  that is the account used to access the shares.   Ensure that account can see the shares and has READ access to it.   That should resolve your issue.

When you do it thru PBI desktop you are running it under your account that has access to the shares etc...

good luck!

Luis.

[luisrh · Accepted solution]

your issue here is more than likely that the service account running PBI Report Server doesn't have access to the share. When refreshing from the service,  that is the account used to access the shares.   Ensure that account can see the shares and has READ access to it.   That should resolve your issue.

When you do it thru PBI desktop you are running it under your account that has access to the shares etc...

good luck!

Luis.

[Anonymous · Accepted solution]

Thanks,

Your post put me in the right direction. The usename and password that had access needed to be added on both servers

[luisrh]

Great to hear!

thanks