Only Retrieve Default List View Columns from SharePoint Online to Power BI Desktop
During this video, we will talk about how we can load the data from the specific ListView to Power BI Desktop. When we are loading data from SharePoint Online List to Power BI Desktop it will load all the columns. This will take some time to load the data into Power BI. With the October 2020 release of Power BI Desktop, Microsoft improved this service, and now we can load the columns from the Default View of SharePoint Online list.
During this video, we will create one SharePoint Online List View, and then set the list view as the default view of the SharePoint list and then load it to Power BI Desktop. Follow the entire video for step by step procedure.
Chapters:
00:00 Introduction
00:26 List View in SharePoint Online
00:53 Create List View
01:54 Set List View as Default View
02:45 Load SharePoint Default View data to Power BI Desktop
03:20 SharePoint Online 2.0 Connector for Power BI
03:34 Only Select Specific View column
04:43 Test
05:05 Benefits
05:25 Limitation
06:03 End
#PowerBI #SharePoint #PowerPlatform #PowerBIWithDhruvin #PowerBIOctoberUpdate #SharePointOnline