Hi Enea, this video was extremely helpful for me to get the attached pdf's into my PowerBI. Though right now i struggle with multiple attachments for the same row. The way i set it up using the video, all rows which have multiple attachments are duplicated. This leads to a major bloat since my list is already pretty big. Is there a way to merge all those URL's for the attachments into a single row ? Thank you for the help.
Hi, thanks happy it helped. It makes sense that you have duplicates since you have multiple attachments for the same row. The way I would handle this is split the list item and its attachments into two tables (you can duplicate the table in Power Query). The first table will contain all your SharePoint List Item information. The second one will contain only the ID of the SharePoint List Item and all the information of the Attachments. Power BI will then create a one-to-many relationship between those two tables automatically (if you have disabled it than do it manually) so that your main table remains distinct and your attachments table can have the duplicates. Then you can play around and figoure out what visualisation suits you best. Hope it helps! Feel free to subscribe to the channel if you like, it will help me as well :)
@@Enea This sounds like the best solution, i was playing around with the Powerquery and grouped the rows by their ID. Then i used the text.combine with a ", " as a delimiter to merge the urls together. Looks nice visually when i put it into a table but powerbi doesnt recognize it as seperate urls so it doesnt work ;). I will try to use two tables like you suggested. Probably gonna use the attachement row which shows "true/false" to tell users that there is a attachement for this entry and then they can look up the attachements in the seperate table. :)
In my case the attachment is true false ... Did I something wrong? or may I change the type? Thx in advance ... Christoph P.S.: I choosed the wrong column ... I have to choose AtachmentFiles :-) Thx for sharing your vid :-)
This is fantastic! And works like a charm! Exactly what I was looking for. One question though, In Power BI when I click on the hyperlink it takes me to the web browser but then immediatly intiates the save function to download the file instead of just showing it in the browser. Any thoughts on why that would happen?
Hey Enea, Thank you so much for the video, very insightful. However, I'm having some difficulties... I created an app in powerapps to submit information in a form format, the user is able to upload pictures, which are saved as attachments. I want o connect my online SP list to PBI, and display my pictures in a table... since the pictures are saved as attachments but not in a column in the List, PBI is not reading the data. Do you know what I could do to fix this?
I'm integrating a sharepointlist that was used as a file repository and I need powerBI to pick up the excel file so that powerBI can do transformation to the data in the Sharepoint List attachment and create an output file. What would you recommend I can do?
@@Enea the data within the excel attachments. Basically there are part numbers within the attachments in share point list that I need to extract into powerbi.
Got it, if you are only dealing with excel files, there might be a way achieving this. The SP List item can be used as a folder and then extract the file content. If you mix them, pdf, excel, word, etc. might become complicated. I will take a look into this, but for now I am on holidays for another week.
Its possible to view a preview of the selected file? I know that we can see a preview of a webpage with HTML but it does not work for sharepoints files
Is there a way to filter through [List] to get the actual values and Visualize the data because I'm using microsoft list and I have a column for choice's For the different Level of Skill proficiency for a specific Skill but when I Import in to Power bi It Show, s as a List
There is. Is your column multiselect? Then it is a table and should be moved in another table. Then you can build a one to many relationship between them. Hope this helps
have more than one attachment in each row within my SharePoint list. Therefore I get more than one row with duplicated information showing the second/third/forth attacdhments. Is there a way to combine this so that the attachments are on one row?
You can group rows in PowerQuery. I don’t see that being helpful though. What you could do is split the tables and have one table with itemID and metadata in distinct and one table with the attachments and itemIDs with duplicates. Then create a 1:n relationship between them over the itemID.
When I do the same thing, the attachment column content in power query shows only ones and zeros and is of type whole number. Basically, the attachment column content indicates if it contains attachment files or not. What could be missing. Thank you
@@saidt.8200 this took a while for me to crack. When you are putting in your site URL, you have to select "Implementation 1.0" the field is not in "implementation 2.0."
@@Enea Hi, this happens because you are using version 2.0 of the 'SharePoint List Connecto'r, the problem with using version 1.0 is that it is too slow to update data.
![ไลฟ์สุ่ม iPhone 295 บาท... โกงมั้ย?[ โกงมั้ยครับ ep.97 ] | DOM](http://i.ytimg.com/vi/gdstHEE4UUE/mqdefault.jpg)
You explain the methods very thoroughly, thanks for the useful information!
Very straightforward, thank you!
thank you for sharing. Learned this straight forwardly.
Hi Enea,
this video was extremely helpful for me to get the attached pdf's into my PowerBI.
Though right now i struggle with multiple attachments for the same row. The way i set it up using the video, all rows which have multiple attachments are duplicated. This leads to a major bloat since my list is already pretty big. Is there a way to merge all those URL's for the attachments into a single row ?
Thank you for the help.
Hi, thanks happy it helped. It makes sense that you have duplicates since you have multiple attachments for the same row. The way I would handle this is split the list item and its attachments into two tables (you can duplicate the table in Power Query). The first table will contain all your SharePoint List Item information. The second one will contain only the ID of the SharePoint List Item and all the information of the Attachments. Power BI will then create a one-to-many relationship between those two tables automatically (if you have disabled it than do it manually) so that your main table remains distinct and your attachments table can have the duplicates. Then you can play around and figoure out what visualisation suits you best. Hope it helps! Feel free to subscribe to the channel if you like, it will help me as well :)
@@Enea This sounds like the best solution, i was playing around with the Powerquery and grouped the rows by their ID. Then i used the text.combine with a ", " as a delimiter to merge the urls together. Looks nice visually when i put it into a table but powerbi doesnt recognize it as seperate urls so it doesnt work ;). I will try to use two tables like you suggested. Probably gonna use the attachement row which shows "true/false" to tell users that there is a attachement for this entry and then they can look up the attachements in the seperate table. :)
In my case the attachment is true false ... Did I something wrong? or may I change the type? Thx in advance ... Christoph P.S.: I choosed the wrong column ... I have to choose AtachmentFiles :-) Thx for sharing your vid :-)
Happy you could solve it by yourself! :)
This is fantastic! And works like a charm! Exactly what I was looking for. One question though, In Power BI when I click on the hyperlink it takes me to the web browser but then immediatly intiates the save function to download the file instead of just showing it in the browser. Any thoughts on why that would happen?
Hey Enea,
Thank you so much for the video, very insightful. However, I'm having some difficulties... I created an app in powerapps to submit information in a form format, the user is able to upload pictures, which are saved as attachments. I want o connect my online SP list to PBI, and display my pictures in a table... since the pictures are saved as attachments but not in a column in the List, PBI is not reading the data. Do you know what I could do to fix this?
Very helpful, thank you! Any updates to work around the API issue other than using older version and having to redo the multiple steps I already did?
Unfortunately not that I know of…:/
I'm integrating a sharepointlist that was used as a file repository and I need powerBI to pick up the excel file so that powerBI can do transformation to the data in the Sharepoint List attachment and create an output file.
What would you recommend I can do?
Check out my newest video coming out tomorrow 9AM (Europe Timezone) ;)
Thank you very much. It went very well-
Hi! Love this! Is there a way to pull attachment data and bring that into the powerbi? I can’t seem to find anything on that. Thank you!
Thanks! What do you mean by attachment data? The content of an Excel Attachment? Or the name of the attachment?
@@Enea the data within the excel attachments. Basically there are part numbers within the attachments in share point list that I need to extract into powerbi.
Got it, if you are only dealing with excel files, there might be a way achieving this. The SP List item can be used as a folder and then extract the file content. If you mix them, pdf, excel, word, etc. might become complicated.
I will take a look into this, but for now I am on holidays for another week.
@@Enea yes, only excel. All in same format. thank you!! Enjoy your holiday! I hope for safe travels for you!
thank you for this!
Thanks good video
Its possible to view a preview of the selected file? I know that we can see a preview of a webpage with HTML but it does not work for sharepoints files
Good question, have not tried it yet. Will do it next!
Is there a way to get the url for each sharepoint list item and add them to the data set and use it as a url icon in the report that we are creating
FYI, I made a video based on your question. Check out my latest video :)
Is it possible to link documents from a local drive?
You can work with local folders and documents but then only on Power BI Desktop.
@@Enea Thank you. I would like to attach files to existing line items in a matrix and table visual. Do you know if this is possible?
@@bxrokk I will do some research and let you know. At this moment I am not sure if it’s possible 👍🏻
@@Enea Thank you!
Is there a way to filter through [List] to get the actual values and Visualize the data because I'm using microsoft list and I have a column for choice's For the different Level of Skill proficiency for a specific Skill but when I Import in to Power bi It Show, s as a List
There is. Is your column multiselect? Then it is a table and should be moved in another table. Then you can build a one to many relationship between them. Hope this helps
have more than one attachment in each row within my SharePoint list. Therefore I get more than one row with duplicated information showing the second/third/forth attacdhments. Is there a way to combine this so that the attachments are on one row?
You can group rows in PowerQuery. I don’t see that being helpful though. What you could do is split the tables and have one table with itemID and metadata in distinct and one table with the attachments and itemIDs with duplicates. Then create a 1:n relationship between them over the itemID.
When I do the same thing, the attachment column content in power query shows only ones and zeros and is of type whole number. Basically, the attachment column content indicates if it contains attachment files or not. What could be missing. Thank you
You need the attachment content, not the „had attachment“ since the last one is a Boolean value true/false or 0/1
@@Enea tried to change the attachment column type in the sp list but it is not listed when viewing the list setup page.
@@saidt.8200 this took a while for me to crack. When you are putting in your site URL, you have to select "Implementation 1.0" the field is not in "implementation 2.0."
+1 can anyone please help us on this
how can we select few item in a list and then click a button which will sum up the data and send it as 1 entity in another list in SharePoint.?
Select a few items in a list you mean in SharePoint or Power BI?
Hello How to show the picture in attachment l cannot the image thank you bro
❤
If it was just jpeg or PNG archives could I show it?
Yes, images can be displayed.
@@Enea does JPG work too?
Bull Shit ... all I can see in the attachment column is the word "true"
All I read is bullshit (btw thats how you write it)
@@Enea Hi, this happens because you are using version 2.0 of the 'SharePoint List Connecto'r, the problem with using version 1.0 is that it is too slow to update data.