Showing results for 
Search instead for 
Did you mean: 
c5vette211 Frequent Visitor
Frequent Visitor

sharepoint library to Bi

I am trying to perform some reporting but not sure the best way to start. I have a sharepoint library (no folders) full of questionnaire in .xls form and other documents. I want to create a report in Power Bi that reports back from just the questionnaire. these questionnaire are submitted by various customers, so i am trying to see how many times the same questions are being asked or variations of certain questions to find trends between customers. Not sure the best way to point Power Bi to each questionnaire then extract that data. Should it be from the Sharepoint Library link or do i have to do each .xls individually? is this task beyond capabilities of power bi?

Community Support Team
Community Support Team

Re: sharepoint library to Bi

Hi @c5vette211

Please refer to this article, if you have any problem, please feel free to ask me.

Power BI: Two Way To Get Data From SharePoint List / Library


Best Regards



c5vette211 Frequent Visitor
Frequent Visitor

Re: sharepoint library to Bi

Thank you for the response. This will get a list of the documents in the library but not help me extract the data from those documents. For example: My library has 4 documents. Each document contains 100 questions. I want to run a report that will extract all 400 questions so I can see trends in the questions. Right now the only way for me to do this would be to open each file copy the 100 questions and paste them into a seperate excel sheet. I would be fine to do this if it was only 4 documents but i have almost 10k documents I would like to do this with. 

Helpful resources

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 294 members 3,213 guests
Please welcome our newest community members: