Forum Discussion
Sharepoint connection error
Hi V-lianl-msft
I was able to connect power bi with mine folder in sharepoint, but right now I am not able to figure out how to load a file from this folder. All the data looks like one table, but I have lots of excel files in my folder and I am thinking how can I access one of them and load it into pbi.
Could you give me a hint about that?
Regards,
Tomasz
Hi V-lianl-msft ,
update - I am able to open the excel file in powerbi from sharepoint, it was successfully done by me.
Right now there is another problem - I would like to make a refresh schedule, I was able to set it in manage section in power bi report server, but while trying to test connection in data sources tab, after using 'Test connection' button I got an error:
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.
SharePoint: Request failed: The underlying connection was closed: An unexpected error occurred on a send.
For both authentication types - anonymous and windows credentials, I am not able to connect to the datasource.
Could you help me with it?
Regards,
Tomasz
Hi t0meky ,
You can refer to this:https://community.powerbi.com/t5/Report-Server/Datasource-can-t-connect-in-Report-Server/td-p/736678
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi,
the issue is (I guess) in authentication than in some errors in an input file.
I am able to use domain authentication (by email and password), but it is not available under my file in a Power Bi Server.
The only authentication available is Anonymous and Windows, which are not working properly while the report preparation.
Regards,
Tomasz
