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

[Anonymous]

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 

[amitchandak · Accepted solution]

@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

[Anonymous]

Hi @amitchandak 

Thank you for your respons, but I need to remove the columns in the source step, is it possibel?

[Anonymous]

Hi @Anonymous ,

I agree with  amitchandak 's reply, when you connect to sharepoint online list, you will get all tables directly instead of filtering columns by query in advance like SQL data source.

So you couldn't remove the columns in the source step. You can upload the tables and then remove columns you don't need in Power Query.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.