Connect to excel file

[Anonymous]

I put an excel file in the powerbi server. Then I connect from powerbi desktop to this file.

I deploy the report, but the connexion web sometimes throws an error

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

The connection is web type and the authentication is windows.

The connection string is like: https://serverpowerbi/Reports/api/v2.0/ressources(idfile)/content/$value

How to correct it? 

[v-kkf-msft]

Hi @Anonymous ,

Does your problem have been solved? If it is solved, please mark a reply which is helpful to you.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

[amitchandak]

@Anonymous , if excel is a location, then you should able to access the same using a shared/network driver.

There is a different method when want to connect using onedrive, sharepoint etc., if want to put on shared location

[Anonymous]

@amitchandak I put the excel file on the power bi server. So I don't understand why sometimes it connects sometimes no. 

[v-kkf-msft]

Hi @Anonymous ,

Please see if these documents are helpful:

Solved: How to Access Excel or CSV Files Saved on Power BI Report Server Directly? 

https://docs.microsoft.com/en-us/power-bi/report-server/configure-kerberos-powerbi-reports 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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