Forum Discussion
Helper ICombining .iqy data from sharepoint to power bi
Hi There,
I trashed my approach for combining .iqy files since I am now directly importing files in sharepoint list. Although having the convenience of Lit view part is good option, I just opt to clean the extracted direct data from Sharpeoint list since when appended and refresh, it works perfectly fine
Community ChampionUse the SharePoint data source connectors?
Doubt anything to do with iqy files will work.
Helper IAlready tried Getting data via sharepoint but the default view does not contain the "Created by" Column which I need that's why I originally though of the .iqy extract
Is there a way to create a new column to mimic the "Created by" column so it shows up the the columns imported to PBI. I creating a new column via calculated columns but the "Created by" column does not show in the options
Hello, do you have an solution about this problem ? i want to do the same thing but i cannot 😞
- Burubear
Hi There,
I trashed my approach for combining .iqy files since I am now directly importing files in sharepoint list. Although having the convenience of Lit view part is good option, I just opt to clean the extracted direct data from Sharpeoint list since when appended and refresh, it works perfectly fine
Thanks, i tried to connect my sharepoint list with option 1 (note option 2 (beta)) and it works fine to expand lists & records 😉
