Connect Power BI to SharePoint List, SharePoint Folder, SharePoint Excel File 🔌

Let me show you how you can connect Power BI to
00:20 SharePoint Folder
05:32 SharePoint Excel File
07:26 SharePoint List
================================
👉 FREE Power BI Step-by-Step Tutorial web.learnpowerbi.com/tutorial
👉 Download Accompanying PBIX Files for Video at web.learnpowerbi.com/download/
✅ Subscribe to always get my latest videos: kzbin.info?su...
🔴 Ask Questions LIVE on TalkPowerBI Fridays kzbin.infolive
👪 Join our Talk Power BI Insider's Club www.TalkPowerBI.com
===Most Popular Playlists===
• Power BI Beginner Tutorial: • Power BI Tutorial From...
• Ultimate Calendar: goo.gl/pyki4K
• Power BI Data Modeling and more: goo.gl/WNtJFv
⚡Power On!⚡
-Avi Singh
www.LearnPowerBI.com
www.AviSing.com
#PowerBI #PowerBIHowTo #PowerBIPro

[@kenmendozaarista7869]

Amazing video! Thank you, mate. For the ones looking for a way to import a file located in sharepoint ( in a different folder than "Documents") go directly to minute 05:42.

[@Lukekiwi1]

Thanks Avi! I really appreciate the thought you put into this video. Not all creators take the time to reflect and think about the specific problems newbies like myself could run into! Great video. Keep up the good work! :)

[@RanjitSingh-yw8fw]

I was struggling to connect the share point file to PowerBI but after watching this video it was done. Really nice video and thank you Avi for your live example.

[@Toorall]

Thank you, it helped a lot! Pity that Microsoft didn't separate reading Excel from SharePoint into a separate option in Get Data, as currently it is not intuitive at all, and I believe it is a very common task

[@morganmcgary921]

This video saved me. Thanks so much for clearing up the jump to combine on SharePoint Folder data sources. When I was trying to refresh data it was breaking because I didn't use the method you showed to exclude all the junk I didn't want from the site so I would get no-key errors.

[@jasonolson4581]

Creating reports from stuff in SharePoint is always an ask. This is so helpful.

[@graemegourlay2850]

Excellent tutorial, worked perfectly for me. I implemented directly as a Dataflow in the Power BI service and the same method worked perfectly.

[@KB-wb9ym]

Hi Avi, I can't thank you enough for this great video mate. Trust me, I was just thinking about to ask you yesterday arvo to post a video on these 3 types of data sources - SharePoint folder, SharePoint Online List & SharePoint list and that's exactly when I got an intimation on my mobile that you've done this video. Nowhere had I found such a demarcating explanation, not even on Microsoft website! Thanks a million mate and as the saying goes.. "Sow Saal Jiyo" and a Happy Diwali. Kind regards, Bhoga

[@hamasalam665]

Thanksss so much for sharing this, I was searching for how to fetch SharePoint excel with no success this helped me a lot

[@garywithu]

Thank you very much. This save me a lot of time that I use to spend on manual refresh.

[@renataarcari1033]

Just what i'm searching for! Thank you so much

[@MrSert187]

you my man are a living legend! been looking for this and you explained and showed it CLEARLY!!

[@PowerBIPro]

Wow! Thanks for that wonderful compliment mate! ⚡Power On!⚡ / Avi ★ Subscribe and Join me LIVE for Talk Power BI Fridays kzbin.infolive ★

[@lasw3017]

Thanks so much Avi, it helped me to resolve one of the issues. Keep up the good work.

[@edwardalarcon7367]

Avi, thanks for the video. I was finally able to connect to my Sharepoint. Perfect!

[@PowerBIPro]

Hi Edward Alarcón. Woohoo glad the video helped you. ⚡Power On!⚡ / Avi ★ Power BI Complete Tutorial: kzbin.info/www/bejne/d3jVnWB-bZyjiLc ★ ★ Get Your Questions Answered LIVE on TalkPowerBI Fridays www.learnpowerbi.com/talkpowerbi ★

[@tomoyat5517]

Recently I came to watch your videos and I realized it’s much better than the one I used to follow. This video was just spot on you are amazing, Period. Thanks Arigato-!

[@PowerBIPro]

Hi Tomoya Tsuruta, Thank you for the amazing compliment! Glad this video has helped you in learning Power BI. ⚡Power On!⚡ / Avi ★ Get Your Questions Answered LIVE on TalkPowerBI Fridays www.learnpowerbi.com/talk ★

[@AndrewRooks]

Thank you THANK YOU THANK YOU!!!!!!!!!!!!!! Spend far to much time trying to get SharePoint Folders to work but in the end your explanation allowed me to achieve what I needed. What would be great is if you could show the same data gather but from a DataFlow in the Services rather than in the Desktop. This being my ultimate aim. Thanks Avi Power ON! Andrew

[@AndrewRooks]

Avi, I have managed to get this into a DataFlow. Thank again for the help, you've made my day! Andrew

[@vinod1908]

Thank you! This video was exactly what I was looking for!! God bless you! :)

[@Globlanco4474]

That was so clear, thanks!

[@orangutanklaus7035]

Perfect!! Such a great tutorial!

[@j.capgemini83]

Simply Brilliant! thanks Avi.... BI Saviour you are!

[@marekgolaszewski2756]

Thank you! You saved my live by this video :-)

[@millyq3407]

amazing! thanks bunch, can we combine this approach to incremental? lets say im sending reports (same layout) everyday to a SP repo and I would like to use those files to feed incremental, is that possible?

[@teo11300]

there's a much easier way of opening a single file (excel etc.) located in sharepoint. Browse to the file, click the 3 dot menu for the file, click details, scroll down the details pane to find the document web path. Copy this url into Power BI as shown in the video.

[@maximedurocher43]

Saved my life again thanks so much!!

[@maximedurocher43]

Saved my life!! Thanks!!

[@isabellejerome1624]

Excellent many thanks very clear for a Frenchy !!!

[@shota3357]

Thanks from japan!

[@pierfrancescogrego5582]

Hi Avi! Thank you very much for the video. How to import in PoweBI all the items including all the related versions of a SharePoint List if the versioning feature has been enabled for the SharePoint List? Sometimes it might be helpful to get and show the data of the previous versions for all the SharePoint List items. I managed to import the latest version only for all the items, but I haven't yet found a solution for the past data of the same items.

[@DataSciencefortheLazy]

Thanks Avi. Very clear on the process. I am still facing credentials issue though. Do we need access to the root itself? I just have access on one of the sub-folders where my excel input file resides.

[@rayromych5534]

Thanks for this video. Got a question though - how can I filter data before its loaded to report from sharepoint list. As we know there is a limit of 5000 that we can load from SP so we would need to filter it.

[@javedmohoboob3501]

exactly what I needed, thanks a lot

[@dariorodriguez6087]

Thank you so soo much man!!!

[@PCaggy1974]

thank you very much. your video helped me to solve the problem while reading a sharepoint folder in excel using power query.

[@PowerBIPro]

Glad to help Paolo. Power On!

[@ginger.schooling]

EXCELLENT VIDEO THANK YOU!

[@yaxmokwa7612]

This was quite helpful. THank you Avi and keep it coming.

[@tonys1499]

Hi Avi - how would one set up the SharePoint as a data cluster in the enterprise data gateway when using both an Oracle source and SharePoint folder or file? Thank you

[@HAiLAUGHEDatTHAT]

Thanks for the help.

[@georgevogiatzis2715]

Great job explaining this sharepoint procedure! Helped me a lot! Subbed!

[@PowerBIPro]

Awesome, thank you!

[@oussamabelyamani8036]

awesome subject , great and detailed content , thanks

[@tomfontanella6585]

Excellent video. Your delivery of information is very clear. I do hit one problem when trying to load data from a Sharepoint list, however. If the list field contains a name that comes from the Active Directory Global Address List, it returns the person's GAL ID, e.g., 1054 , not their name.

[@soniaortega6566]

I am also wondering how to convert and show the name displayed on the Sharepoint list. Please let me know if anyone knows how to change those columns.

[@91Fick]

thank you!

[@laviecest5811]

Very helpful tutorial. Thanks for this.

[@vaishnavinalawade9904]

Thank you so much! I did it!

[@kinsellapinky9358]

Thanks Avi... You saved my life

[@suleidyhernandezcarratala5995]

Thanks for your video. Finally, I was able to connect to many shareporpoint folders in one report but any time that I enter on it the report ask me for my credentials, it's normal? I put my Microsoft account but any time I need to do it?

[@hussains2898]

Very helpful and easy to follow instructions. Thanks a lot

[@PowerBIPro]

Hi Hussain S, So nice of you to leave a positive feedback, Hussain. Means a lot to me. ⚡Power On!⚡ / Avi ★ Get Your Questions Answered LIVE on TalkPowerBI Fridays www.learnpowerbi.com/talk ★

[@kingtawa]

Thank you very much Avi.

[@RRangel7b]

Thank you ~!

[@mapa5000]

Sharp !!! Thank you !!!

[@orbivictting5470]

Using the Web import method and specifying the Excel file, how do you setup scheduled refreshes to pull in any changes made to the excel file. This is from the point of view of self-hosted PBI Report server, not Power BI Service! ? When in PBI desktop you get the option to login with organisational/microsoft o365 account. but that options isn't available when setting up the data source in PBI RS.

[@diederikdelange3135]

Thanks mate :)

[@neil3812]

Brilliant!

[@robertlaurie8658]

Thanks for the video. The thing is when you connect a sharepoint folder, it doesnt give you each of the fields to use in the report itself...it gives you generic things like 'type'

[@JavierHernandezKuret]

Thank you!

[@PowerBIPro]

You're welcome!

[@tamer.abdelaal]

@4:35 If you click on "Binary" there it will lead you directly to the file you need, from there you need to click on "Table" and you will get exactly what you need!

[@giftboxtj2381]

Thank you , very helpful !!

[@PowerBIPro]

Hi Gift Box TJ, Thanks mate! ⚡Power On!⚡ / Avi ★ Get Your Questions Answered LIVE on TalkPowerBI Fridays www.learnpowerbi.com/talk ★

[@hunterrheaume8689]

You are the man! Thanks for sharing, very helpful. (I subscribed)

[@dianajimenez2557]

Hello! Thank you so much for the video. It works. However, I have a report published and it is automatically refresh but it seems to have problems refreshing the Sara form the folder because it is attached to my user. Is there any way to fix this ?

[@johnpauldelacruz7957]

Hi, Excellent work on it. May I ask if can I connect to someone's sharepoint folder that has been shared to me including the sub-folder and sub files. Because here you have query it successfully as it is your own sharepoint folder but what if it is not your sharepoint folder? Makes sense? Additional on it, I want to query also the version history of the sharepoint folder and files which I do not own but has just shared to me. Thanks!

[@SamehKaddoura]

Really helpful, thanks for the effort!

[@PowerBIPro]

Glad it was helpful!

[@artemburov9456]

Hi Avi. So simple! Thank you

[@PowerBIPro]

Hi Artem Burov, You're welcome! ⚡Power On!⚡ / Avi ★ Get Your Questions Answered LIVE on TalkPowerBI Fridays www.learnpowerbi.com/talk ★

[@mitaliprajapati5172]

Really Great Stuff!!!

[@PowerBIPro]

Thanks for the feedback

[@matchanista2762]

This is an amazing video!! Thank you so much for this

[@PowerBIPro]

Glad you liked it!

[@nilsonbatista852]

Hey Avi, watching your video in 2022 and it helped me a lot! thanks for sharing!

[@PowerBIPro]

Glad you found it useful. We are having an exciting event going on--> Get Your Free Pass 🎟️ at lnkd.in/fw-XvmC ^RM

[@venezuela9230]

Thanks so much! I was lost!

[@PowerBIPro]

Glad I could help!.Thank you for your feedback. If you'd like to learn more about Power BI , here is a link about our structured course on this Webinar 👉 web.learnpowerbi.com/waitlist-invite/ ^RM

[@DataAnalytics2486]

This is such a great tutorial!

[@PowerBIPro]

Glad you think so!

[@dhruuv7772]

Really saved my day thanks Avi

[@PowerBIPro]

Hi dhruuv 777. I'm glad this video has helped you. ⚡Power On!⚡ / Avi ★ Power BI Complete Tutorial: kzbin.info/www/bejne/d3jVnWB-bZyjiLc ★ ★ Subscribe and Join me LIVE for Talk Power BI Fridays kzbin.infolive ★

[@jameswhite6120]

Thanks!

[@PowerBIPro]

Welcome!

[@guptaprashantkumar]

Hi, Thanks for the video. I was able to connect to sharepoint from power query and prepared my report in excel through power pivot. But when I am sharing it with other user within the same group, they are getting refresh error? Any help?

[@frankievargasgamboa2147]

Hi, thanks for the video! What happens if I want to select csv files from sharepoint ?

[@francoismartinez3804]

thnx man helped me a lot for work !

[@PowerBIPro]

Glad I could help

[@guapo2012]

thank you for your valuable video. this helped me a lot

[@PowerBIPro]

Am glad you found this useful Josue. if you have any questions you can get them answered in our LIVE TalkPowerBI Q&A show. 👉 www.TalkPowerBI.com Or Join our LearnPowerBI Private Community 👉 web.learnpowerbi.com/waitlist-invite/ ^RM

[@jsx0328]

Incredible video

[@PowerBIPro]

Thank you. Am glad you found this useful. if you have any questions you can get them answered in our LIVE TalkPowerBI Q&A show. 👉 www.TalkPowerBI.com Or Join our LearnPowerBI Private Community 👉 web.learnpowerbi.com/waitlist-invite/ ^RM

[@jumpofjoy8815]

Thank you for this video! What happens if I need to add more files in the share point folder selected in your example? Will they be combined automatically with the ones already there or I have to repeat the selection process all over again? I find it weird that we cannot just point out the full folder path in share point like we do with local folders.

[@kenmendozaarista7869]

I think that if the files you want to combine are in same folder, you will be able to combine them. Take into account that when you are inside power query you can combine/append as many tables as you want.

[@ahv5457]

Thanks Avi. I'd like to load each of those Binary rows into a separate table rather than combining them into one single table because they all have different contents (columns and rows). I have saved all these tables in one path in a SharePoint. How to da that?

[@josejoseph1428]

Nice video and your explanation is excellent

[@haydn.oneill]

brilliant, nice and simple, well presented.

[@PowerBIPro]

Hi Haydn de Quiroz O'Neill. Thanks for the feedback. I appreciate it. ⚡Power On!⚡ / Avi ★ Power BI Complete Tutorial: kzbin.info/www/bejne/d3jVnWB-bZyjiLc ★ ★ Get Your Questions Answered LIVE on TalkPowerBI Fridays www.learnpowerbi.com/talkpowerbi ★

[@trevormay8486]

Hi Avi! Do you have any resources or help on doing this same process in Power Query Online? I have an excel table that is in a sharepoint folder that I'm trying to add to my dataflow but I just keep getting 'Invalid Credentials' errors.

[@vinaykumarsingh8744]

Thanks a ton, well explained. Can you create one for web API, Its prerequisites to source data for power BI using API

[@guimatheus92]

Hi! I can't find a better option than you, I searched all over, but you make a good explanation! Can you please (really!), help to get the URL from images in a folder from Sharepoint to PowerBI? Because if I follow the same steps as this video, it shows me an error, that it doesn't support JPEG, PNG, etc. Thanks

[@abdullahghrab4128]

Hi Thanks for the video 😊 Is there any way to connect power BI to .mpp file that’s the extension for Microsoft Projects?

[@santiagotorozuluaga5863]

Hello, thank you very much for the video. Do you know how to get the metadata from Sharepoint lists with PowerBI? Hola, muchas gracias por el video. Sabes como obtener los metadatos de las listas de Sharepoint con PowerBI?

[@minstreltokunbo]

Thank you for this video. I am very new to Power BI and connections. Does this mean when you connect directly to the list or folder and you create dashboards, it updates automatically? More like a real-time data?

[@kenmendozaarista7869]

Importing data from sharepoint is a very nice first step to get your Power BI dashboards/reports automatically updated. A next step would be to configure the updates frequency in Power BI service. Take into in account that for doing so you need a paid account.

[@novak2033]

Hi Avi, nice video. Would be great great if you could show how does this work once published to Service. Any specifics / tricks? Is gateway needed or not?

[@spilledgraphics]

good question!, hopefully he answers soon!

[@smailmaksen8528]

Hello Avi! Awesome presentation. I have a real problem when connecting to a sharepoint online List. The data provided in the columns after making the first query looks like "​asdf" the text inside isn't shown. What can I do? Can you help??

[@saileepawar3301]

Hi Avi!! Thanks for the video. I was able to trouble shoot and connect to one of the files in Sharepoint. Next question I have is - How can I have this fiile on Auto refresh? I have shared the file online with my stakeholders and would like PBI to show real time data as soon as the file gets updated. Thanks!!

[@shabihulhasnain1164]

Hi, There is schedule refresh option available in Web version that you can use, it has option to refresh 7-8 times per day.

[@angelicalozano7085]

Hi Sailee... Do you know how to activate the auto refresh?

[@Picla_Peremohy]

@@angelicalozano7085 refresh is set on the dataset. Check your license, though. I don't think the free version allows for it. Pro gets you some. Premium or PPU allows more, such as merges and references in the editor. As things change over time, please verify with the current MS licensing.

[@josesortegaluis8821]

great! it helped me to solve a problem!

[@PowerBIPro]

Hi Jose Sortega Luis. Glad it helped you! ⚡Power On!⚡ / Avi ★ Power BI Complete Tutorial: kzbin.info/www/bejne/d3jVnWB-bZyjiLc ★ ★ Get Your Questions Answered LIVE on TalkPowerBI Fridays www.learnpowerbi.com/talkpowerbi ★

[@maltenee6356]

thanks, it helps a lot :-)

[@PowerBIPro]

Glad it helped!

[@magdajankowska502]

Hi Avi. This video is great and it helped me a lot! Thanks ;)

[@PowerBIPro]

Hi Magda Jankowska, Happy to hear that! Absolutely! ⚡Power On!⚡ / Avi ★ Get Your Questions Answered LIVE on TalkPowerBI Fridays www.learnpowerbi.com/talk ★

[@munkybutler1]

Hi Avi, I have a SharePoint list with 10,000 rows as my datasource. The Power BI refresh is extremely slow, takes up to an hour and often doesn't even work. Do you have a recommended limit of SharePoint list rows for import to Power BI? Thanks.

[@heinrichpainczyk1591]

Great Video thanks!!! Have you covered PowerBI errors by any chance? I constantly get them yet it doesnt seem to affect anything.

[@PowerBIPro]

Great suggestion!

[@shashirajusiddaraju4979]

Super 👌, Thanks for the video Avi! 😊

[@PowerBIPro]

My pleasure 😊

[@beregu]

Can you export the transformed data you built on Power Query to Sharepoint List using Power Query and set auto refresh timer?

[@1yyymmmddd]

Hi. How do you get this Open in Desktop App tab there? I don't see it in my file open in Sharepoint.

[@puretech9247]

And what if the report created in the power bi desktop and then uploading that report to sharepoint , will it reflect the current data after every refresh ?

[@ileanapodesta7439]

Hi Avi, thanks for this! I've built reports based on a local file. Now I uploaded the file to SharePoint but when trying to change the Data Source in PowerBI Desktop my credentials fail. I just wanted to know if what I'm trying to do is something doable regardless permission issues. Thank you!

[@PowerBIPro]

Marianne from Team Avi. Sorry Avi, was not able to get to your comment. If you're still stuck and need help we would recommend submitting the question to our LIVE TalkPowerBI Q&A Session www.learnpowerbi.com/talkpowerbi#qa

[@KevinMach5]

Hi Avi, Thanks for the video was very helpful but I could not get it work with for my sharepoint. When I pass in the root sharepoint URL and connect with the Power BI Sharepoint connector I get the following error: Details: " We found extra characters at the end of JSON input" Have you encountered this before / know how to get around this? Thanks Kevn

[@dineshgandhi3169]

Singh is king ❤ thanks for the info man very clearly explained

[@etherlords88]

How to set the gateway cluster for this to setup schedule refresh?

[@shruthil7913]

Awesome it really helped me :-)

[@PowerBIPro]

Hi Shruthi L, Glad it helped! ⚡Power On!⚡ / Avi ★ Get Your Questions Answered LIVE on TalkPowerBI Fridays www.learnpowerbi.com/talkpowerbi ★