Forum Discussion
Helper IIWhen getting data from Sharepoint Online list. I pull in the data but the tables created have severa
When getting data from Sharepoint Online list using PowerBI. I pull in the data but the tables created have many columns with [Table] in them. I need the data inside these columns as well. How can I get them the best and easiest way to do this just one time instead of Transforming them constantly? As the data is constantly changing for the report being build. Thanks
Hi ResearchDev ,
In my opinion, you can open multiple connections to connect to multiple SharePoint sites in Power BI Desktop, then you can open Query Editor to use Merge Queries or Append Queries features. When you have one or more columns that you'd like to add to another query, you merge the queries. When you have additional rows of data that you'd like to add to an existing query, you append the query.
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- lbendlin
Super User
Use the ODATA connector and indicate which fields you want expanded. Warning: Too many field expansions will slow down your connection dramatically.
V-lianl-msftCommunity Support
Hi ResearchDev ,
In my opinion, you can open multiple connections to connect to multiple SharePoint sites in Power BI Desktop, then you can open Query Editor to use Merge Queries or Append Queries features. When you have one or more columns that you'd like to add to another query, you merge the queries. When you have additional rows of data that you'd like to add to an existing query, you append the query.
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ResearchDevThank you everyone. I appreciate it much.
