cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
user_jivani Frequent Visitor
Frequent Visitor

Auto refresh data in power BI dekstop from excel spreadsheet extracted from sharepoint survey

I'm uploading data from Excel spreadsheet which is extracted from Sharepoint survey. Now for every survey which is filled out, i need to update that data in Power BI without extracting new excel sheet from sharepoint every time or opening the existing excel sheet and refreshing it and save again and again.

 

As far as i know, only option to extract data from Sharepoint survey is Excel Spreadsheet. Possible options to Get data in Power BI are Excel, Sharepoint online list, Sharepoint List, Web, OData Feed and Sharepoint Folder. I've tried all the possible options (Which i know) to get the updated data every time in Power BI but i'm not able to do it. Please can someone help me with this issue ?

1 ACCEPTED SOLUTION

Accepted Solutions
Stachu Super Contributor
Super Contributor

Re: Auto refresh data in power BI dekstop from excel spreadsheet extracted from sharepoint survey

I connected to survey I created using SharePoint online list connector, the address input was from the site that hosted the survey, not linking to the survey itself, i.e.
https://mysite.sharepoint.com/sites/mysite
have you tried that?

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

4 REPLIES 4
Stachu Super Contributor
Super Contributor

Re: Auto refresh data in power BI dekstop from excel spreadsheet extracted from sharepoint survey

I connected to survey I created using SharePoint online list connector, the address input was from the site that hosted the survey, not linking to the survey itself, i.e.
https://mysite.sharepoint.com/sites/mysite
have you tried that?

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

user_jivani Frequent Visitor
Frequent Visitor

Re: Auto refresh data in power BI dekstop from excel spreadsheet extracted from sharepoint survey

I have done this and i'm able to get the updated data but the problem is data which i got through this method is very messy and cleaning data is very difficult. 

Highlighted
Stachu Super Contributor
Super Contributor

Re: Auto refresh data in power BI dekstop from excel spreadsheet extracted from sharepoint survey

well I guess it's a trade off between the connectivity and the data processing, but I don't believe it would be too difficult to format the data in a structured manner

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

user_jivani Frequent Visitor
Frequent Visitor

Re: Auto refresh data in power BI dekstop from excel spreadsheet extracted from sharepoint survey

Yeah you are right. I'm moving forward with this option.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 121 members 1,273 guests
Please welcome our newest community members: