Forum Discussion
Connect to excel file
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?
4 Replies
- amitchandak
Super User
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
amitchandak I put the excel file on the power bi server. So I don't understand why sometimes it connects sometimes no.
v-kkf-msftCommunity Support
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,
WinnizIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- 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
