Reply
New Member
Posts: 1
Registered: ‎02-07-2019

Can't connect to Sharepoint subsites using PowerBI

Dear´s

 

I try to connect data on SharePoint on line list and receive this error..please somebody can help me to solve this?

"DataSource.Error: SharePoint: Error en la solicitud: Error en el servidor remoto: (500) Error interno del servidor. (La consulta no se puede completar porque el número de columnas de búsqueda que contiene supera el umbral de columnas de búsqueda establecido por el administrador.)
Detalles:
DataSourceKind=SharePoint
DataSourcePath=https://abacoasesores.sharepoint.com/sites/Intranet
SPRequestGuid=7795bd9e-e0c1-0000-4d58-e5fb16bc9221
Url=https://abacoasesores.sharepoint.com/sites/Intranet/_api/Web/Lists(guid'4b8cf745-a0ce-468e-a857-672d..."

 

thks

Highlighted
Community Support Team
Posts: 2,961
Registered: ‎02-06-2018

Re: Can't connect to Sharepoint subsites using PowerBI

Hi @JosePBI1,

 

It seems that you have problems when you get data with SharePoint online list.

 

There're two ways for us to get data from SharePoint online list, which do you use? OData Feed or SharePoint Online list connector?

 

In addition, you could refer to this similar thread which may help you.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor
Posts: 13
Registered: ‎07-19-2018

Re: Can't connect to Sharepoint subsites using PowerBI

Hi Jose,

 

Please try below.

 

 

 

Add new dataset from Sharepoint folder.

Capture.JPG

 

Fill in link to sharepoint folder, please do not put "/" after folder name

Capture1.JPG

 

Log in using microsoft account and connect.

 

Capture2.JPG

 

Once table preview will load, go and hit "Edit"

Capture3.JPG

Then query will open, looking like this. Find file which you want to connect and just click right on "Binary" and choose "Add as new query" so you don't have to go trough whole setup when more files are needed.

Capture4.JPG

 

LEt me know, if any questions.

 

Rasty