- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
Auto refresh data in power BI dekstop from excel spreadsheet extracted from sharepoint survey
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-14-2018 03:11 AM
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 ?
Solved! Go to Solution.
Accepted Solutions
Re: Auto refresh data in power BI dekstop from excel spreadsheet extracted from sharepoint survey
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-14-2018 03:48 AM
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?
All Replies
Re: Auto refresh data in power BI dekstop from excel spreadsheet extracted from sharepoint survey
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-14-2018 03:48 AM
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?
Re: Auto refresh data in power BI dekstop from excel spreadsheet extracted from sharepoint survey
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-14-2018 04:33 AM
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.
Re: Auto refresh data in power BI dekstop from excel spreadsheet extracted from sharepoint survey
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-14-2018 05:02 AM
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
Re: Auto refresh data in power BI dekstop from excel spreadsheet extracted from sharepoint survey
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-14-2018 05:31 AM
Yeah you are right. I'm moving forward with this option.