Hello all I have a sharepoint list with around 50 columns, I need to connect it to power bi but it takes long time in loading and refresh, is there a way to select specific columns before I connect it to power bi? because I just use only 10 columns. Thank you

Anonymous , At the time of selection, try to go to transform data directly. Of try add data in the power query. Then you can remove the column in the first step. For Few Sources like SQL , you have advance option to give a query, where you can select column. But I doubt you have something like that for sharepoint

Select specific columns from sharepoint online list before connecting to Power BI

Forum Discussion

Related content

OData Error When Connecting to SharePoint Online

Sharepoint Connection

Connecting to sharepoint

Sharepoint Folder Connection – Access Required

Connecting Sharepoint Folder to PowerBI