Power BI: How To Connect To SharePoint Online
Follow along as Jonathon shows how to connect into a SharePoint Folder and SharePoint List with Power BI to access data stored in the cloud.
00:00 - Introduction to Power BI and Connecting to SharePoint
00:50 - Accessing Power BI's Get Data Option and Filtering for SharePoint
01:59 - Obtaining the Correct Site URL from SharePoint for Connection
03:48 - Handling Credentials for SharePoint Connection in Power BI
06:04 - Opening Power Query to Transform and Filter SharePoint Data
08:51 - Combining Multiple Files from SharePoint into a Single Table
10:19 - Proactive Removal of Nulls in the Transform Sample File for Future Files
14:56 - Connecting to a SharePoint List, Selecting Columns, and Setting Data Types
15:15 - Closing Remarks
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: tinyurl.com/2ujujsb5
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: blog.pragmaticworks.com/
Let's connect:
✔️Twitter: / pragmaticworks
✔️Facebook: / pragmaticworks
✔️Instagram: / pragmatic.works
✔️LinkedIn: / pragmaticworks
✔️KZread: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: training@pragmaticworks.com
#PragmaticWorks #JonathonSilva
Пікірлер: 20
Thank you for the tips! Great video!
IT HELPED ME SO MUCH !!!! THANKS
Great explanation Thanks
Awesome work guys This helped me alot
@PragmaticWorks
Жыл бұрын
Happy to help! 🙂
We have to be careful when combining datasets as the nulls on some tables may have filled fields with data on others. How do we keep all values, with no nulls in order to have an accurate data representation oir values? Of course, in the case of creating relational databases. Can anyone answer my question? Thanks! This video was very helpful!
I loved the tip on removing nulls in the transform files.
@PragmaticWorks
Жыл бұрын
Thanks for watching! Glad you enjoyed.
Useful and short, thanks a lot man!
Nice one.
Thank you! Been working on connecting to an excel file in share point and this was helpful
@PragmaticWorks
Жыл бұрын
Glad it helped!
nice and smooth, but after the report gets published on the PowerBI Service, can it be refreshed with new data from the Sharepoint?
@yi-jiuntang6236
9 ай бұрын
I want to know how to refresh new data from sharepoint too.
Thx for the video ... Just one question ... I always got an error messages during updating data ... Using connect to sharepoint folder ... IAfter the error message I can visualize date ... You got any idee for error message? Thx in advance ... Greetings from Koblenz, Germany ... Christoph🤗
Hi, thank you> How can I connect a sharepoint file to power bi service to create a report and refresh it. thank you
5:54 cannot, the files in the sharepoint does not come up
@bhapapathvisutvatanasak9329
7 ай бұрын
6:17 data transformation and query stuff
everything was good until 9:48 and then nothing went into my brain anyone else?
Well, Video could be around 8 ~ 10 minutes. . . .extended that making bore