Forum Discussion
Select specific columns from sharepoint online list before connecting to Power BI
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
3 Replies
- amitchandak
Super User
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
Hi amitchandak
Thank you for your respons, but I need to remove the columns in the source step, is it possibel?
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.