there's a much easier way of opening a single file (excel etc.) located in sharepoint. Browse to the file, click the 3 dot menu for the file, click details, scroll down the details pane to find the document web path. Copy this url into Power BI as shown in the video.
I was struggling to connect the share point file to PowerBI but after watching this video it was done. Really nice video and thank you Avi for your live example.
Thank you, it helped a lot! Pity that Microsoft didn't separate reading Excel from SharePoint into a separate option in Get Data, as currently it is not intuitive at all, and I believe it is a very common task
@4:35 If you click on "Binary" there it will lead you directly to the file you need, from there you need to click on "Table" and you will get exactly what you need!
Using the Web import method and specifying the Excel file, how do you setup scheduled refreshes to pull in any changes made to the excel file. This is from the point of view of self-hosted PBI Report server, not Power BI Service! ? When in PBI desktop you get the option to login with organisational/microsoft o365 account. but that options isn't available when setting up the data source in PBI RS.
Amazing video! Thank you, mate. For the ones looking for a way to import a file located in sharepoint ( in a different folder than "Documents") go directly to minute 05:42.
Excellent video. Your delivery of information is very clear. I do hit one problem when trying to load data from a Sharepoint list, however. If the list field contains a name that comes from the Active Directory Global Address List, it returns the person's GAL ID, e.g., 1054 , not their name.
Hi Avi!! Thanks for the video. I was able to trouble shoot and connect to one of the files in Sharepoint. Next question I have is - How can I have this fiile on Auto refresh? I have shared the file online with my stakeholders and would like PBI to show real time data as soon as the file gets updated. Thanks!!
@@angelicalozano7085 refresh is set on the dataset. Check your license, though. I don't think the free version allows for it. Pro gets you some. Premium or PPU allows more, such as merges and references in the editor. As things change over time, please verify with the current MS licensing.
This video saved me. Thanks so much for clearing up the jump to combine on SharePoint Folder data sources. When I was trying to refresh data it was breaking because I didn't use the method you showed to exclude all the junk I didn't want from the site so I would get no-key errors.
Thanks Avi! I really appreciate the thought you put into this video. Not all creators take the time to reflect and think about the specific problems newbies like myself could run into! Great video. Keep up the good work! :)
Thanks for this video. Got a question though - how can I filter data before its loaded to report from sharepoint list. As we know there is a limit of 5000 that we can load from SP so we would need to filter it.
Thank you for this video. I am very new to Power BI and connections. Does this mean when you connect directly to the list or folder and you create dashboards, it updates automatically? More like a real-time data?
Importing data from sharepoint is a very nice first step to get your Power BI dashboards/reports automatically updated. A next step would be to configure the updates frequency in Power BI service. Take into in account that for doing so you need a paid account.
Thanks Avi. Very clear on the process. I am still facing credentials issue though. Do we need access to the root itself? I just have access on one of the sub-folders where my excel input file resides.
Hello! Thank you so much for the video. It works. However, I have a report published and it is automatically refresh but it seems to have problems refreshing the Sara form the folder because it is attached to my user. Is there any way to fix this ?
Hi Avi, nice video. Would be great great if you could show how does this work once published to Service. Any specifics / tricks? Is gateway needed or not?
Thank you THANK YOU THANK YOU!!!!!!!!!!!!!! Spend far to much time trying to get SharePoint Folders to work but in the end your explanation allowed me to achieve what I needed. What would be great is if you could show the same data gather but from a DataFlow in the Services rather than in the Desktop. This being my ultimate aim. Thanks Avi Power ON! Andrew
Hi! I can't find a better option than you, I searched all over, but you make a good explanation! Can you please (really!), help to get the URL from images in a folder from Sharepoint to PowerBI? Because if I follow the same steps as this video, it shows me an error, that it doesn't support JPEG, PNG, etc. Thanks
Hi, Excellent work on it. May I ask if can I connect to someone's sharepoint folder that has been shared to me including the sub-folder and sub files. Because here you have query it successfully as it is your own sharepoint folder but what if it is not your sharepoint folder? Makes sense? Additional on it, I want to query also the version history of the sharepoint folder and files which I do not own but has just shared to me. Thanks!
Hi Avi ! Great resource ! I have followed your advice but I am still having trouble connecting our Sharepoint Online Excel document to the Power Bi, we keep getting an error message "Access to the resource is forbidden", do you have any tips of suggestions please !
Wow! Thanks for that wonderful compliment mate! ⚡Power On!⚡ / Avi ★ Subscribe and Join me LIVE for Talk Power BI Fridays ruclips.net/user/PowerBIProlive ★
Hello Avi! Awesome presentation. I have a real problem when connecting to a sharepoint online List. The data provided in the columns after making the first query looks like "asdf" the text inside isn't shown. What can I do? Can you help??
Thank you for this video! What happens if I need to add more files in the share point folder selected in your example? Will they be combined automatically with the ones already there or I have to repeat the selection process all over again? I find it weird that we cannot just point out the full folder path in share point like we do with local folders.
I think that if the files you want to combine are in same folder, you will be able to combine them. Take into account that when you are inside power query you can combine/append as many tables as you want.
Hi Avi, I can't thank you enough for this great video mate. Trust me, I was just thinking about to ask you yesterday arvo to post a video on these 3 types of data sources - SharePoint folder, SharePoint Online List & SharePoint list and that's exactly when I got an intimation on my mobile that you've done this video. Nowhere had I found such a demarcating explanation, not even on Microsoft website! Thanks a million mate and as the saying goes.. "Sow Saal Jiyo" and a Happy Diwali. Kind regards, Bhoga
Hi Hussain S, So nice of you to leave a positive feedback, Hussain. Means a lot to me. ⚡Power On!⚡ / Avi ★ Get Your Questions Answered LIVE on TalkPowerBI Fridays www.learnpowerbi.com/talk ★
And what if the report created in the power bi desktop and then uploading that report to sharepoint , will it reflect the current data after every refresh ?
Thank you for that tutorial, but main thing for me stays the same - i donk know how to get dashbord refrashed on local company server with power bi dashbords :( And my personal specific is that i am connecting to a lical SharePOint List (not online because sharepoint list online does not have possibiliti to refresh by schadules ) So how it shoud be done ?
The first method: You combined several Excel files from a Sharepoint folder. What if those 3 excel files have different columns and data? Will it make 3 seperate queries for it?
I'm getting data from a SharePoint Excel File. This works fine on power bi desktop but when I publish, my azure credentials don't work, how do you properly set it up on Power BI Online?
Hi Avi, thanks for this! I've built reports based on a local file. Now I uploaded the file to SharePoint but when trying to change the Data Source in PowerBI Desktop my credentials fail. I just wanted to know if what I'm trying to do is something doable regardless permission issues. Thank you!
Marianne from Team Avi. Sorry Avi, was not able to get to your comment. If you're still stuck and need help we would recommend submitting the question to our LIVE TalkPowerBI Q&A Session www.learnpowerbi.com/talkpowerbi#qa
Hi Edward Alarcón. Woohoo glad the video helped you. ⚡Power On!⚡ / Avi ★ Power BI Complete Tutorial: ruclips.net/video/AGrl-H87pRU/видео.html ★ ★ Get Your Questions Answered LIVE on TalkPowerBI Fridays www.learnpowerbi.com/talkpowerbi ★
I used these instructions to connect an Excel file, hosted on SharePoint, which seems to have worked fine. However, my data are not updating when I click "refresh"....Not sure what I'm doing wrong....
Hi Avi, Love the Video ans it is working:) I have another issue with the BI Sharepoint Connect,aybe you can Help me. I have a Sharepoint Bibliothek with document's in SUB folders, all Documents have Meta Data Like Responsible Person, valid areas and so on. If i now try to collect that Data with in Bi IT only show's Numbers instead of the Responsible Name and IT Shows only "list" by assigend areas.
Hi Avi! Do you have any resources or help on doing this same process in Power Query Online? I have an excel table that is in a sharepoint folder that I'm trying to add to my dataflow but I just keep getting 'Invalid Credentials' errors.
Recently I came to watch your videos and I realized it’s much better than the one I used to follow. This video was just spot on you are amazing, Period. Thanks Arigato-!
Hi Tomoya Tsuruta, Thank you for the amazing compliment! Glad this video has helped you in learning Power BI. ⚡Power On!⚡ / Avi ★ Get Your Questions Answered LIVE on TalkPowerBI Fridays www.learnpowerbi.com/talk ★
Thanks Avi. I'd like to load each of those Binary rows into a separate table rather than combining them into one single table because they all have different contents (columns and rows). I have saved all these tables in one path in a SharePoint. How to da that?
Hi Avi - how would one set up the SharePoint as a data cluster in the enterprise data gateway when using both an Oracle source and SharePoint folder or file? Thank you
Hello, thank you very much for the video. Do you know how to get the metadata from Sharepoint lists with PowerBI? Hola, muchas gracias por el video. Sabes como obtener los metadatos de las listas de Sharepoint con PowerBI?
Am glad you found this useful Josue. if you have any questions you can get them answered in our LIVE TalkPowerBI Q&A show. 👉 www.TalkPowerBI.com Or Join our LearnPowerBI Private Community 👉 web.learnpowerbi.com/waitlist-invite/ ^RM
Marianne from Team Avi. Sorry Avi, was not able to get to your comment. If you're still stuck and need help we would recommend submitting the question to our LIVE TalkPowerBI Q&A Session www.learnpowerbi.com/talkpowerbi#qa
Hey Solvex, Can you elaborate a bit. With Uploads do you mean, you just want to get a count of the files uploaded to a SharePoint folder? And Downloads is how many times the file was downloaded (this may not be easy to get I think). Power On! / Avi
Thanks for the video. The thing is when you connect a sharepoint folder, it doesnt give you each of the fields to use in the report itself...it gives you generic things like 'type'
Thank you. Am glad you found this useful. if you have any questions you can get them answered in our LIVE TalkPowerBI Q&A show. 👉 www.TalkPowerBI.com Or Join our LearnPowerBI Private Community 👉 web.learnpowerbi.com/waitlist-invite/ ^RM
Hi.. I posted a question on another video of yours but I think this is more relevant. I have the same SharePoint file connected to two different pbix file. I created visuals on one, copy and paste the visuals on the other pbix file. Usually it works for other datasets.. but it didn't work on files connected to SharePoint. I also tried to copy the advanced editor data in query editor to the other pbix file. Yet it didn't work. Can you please help?
Thanks for your video. Finally, I was able to connect to many shareporpoint folders in one report but any time that I enter on it the report ask me for my credentials, it's normal? I put my Microsoft account but any time I need to do it?
Hi!!! Nice to meet you :) I need help with an issue connecting to Sharepoint online List. Could you help me? Please, I'll appreciate it. It seems that the connection is Ok, according to this video. I refresh the power BI but the new information doesn't appear in the power BI, I have only the information when I did the connection, since that day my power BI doesn't actualize although I Refresh All the power BI by myself. Thanks for the help Regards
Hi, would it be possible to explain how to CHANGE the source to SharePoint Folder or File or OneDrive? Having tried many times so far, we got various errors. Thanks a lot.
Hi, Thanks for the video. I was able to connect to sharepoint from power query and prepared my report in excel through power pivot. But when I am sharing it with other user within the same group, they are getting refresh error? Any help?
Hi Avi, Thanks for the video was very helpful but I could not get it work with for my sharepoint. When I pass in the root sharepoint URL and connect with the Power BI Sharepoint connector I get the following error: Details: " We found extra characters at the end of JSON input" Have you encountered this before / know how to get around this? Thanks Kevn
Glad I could help!.Thank you for your feedback. If you'd like to learn more about Power BI , here is a link about our structured course on this Webinar 👉 web.learnpowerbi.com/waitlist-invite/ ^RM
amazing! thanks bunch, can we combine this approach to incremental? lets say im sending reports (same layout) everyday to a SP repo and I would like to use those files to feed incremental, is that possible?
I use this in Power Query to create a link to a file in Sharepoint site. The issue is it works but when I add files or rename them on the Sharepoint side and do another query to the Sharepoint folder to a file it keeps giving me the list of file names when I did it the first time. I do not get an option to refresh the view so I can see the new files as well. I tried Refresh All and then tried a new query to the same Sharepoint Folder. Please help.
Marianne from Team Avi. Sorry Avi, was not able to get to your comment. If you're still stuck and need help we would recommend submitting the question to our LIVE TalkPowerBI Q&A Session www.learnpowerbi.com/talkpowerbi#qa
Hi Avi! Thank you very much for the video. How to import in PoweBI all the items including all the related versions of a SharePoint List if the versioning feature has been enabled for the SharePoint List? Sometimes it might be helpful to get and show the data of the previous versions for all the SharePoint List items. I managed to import the latest version only for all the items, but I haven't yet found a solution for the past data of the same items.
there's a much easier way of opening a single file (excel etc.) located in sharepoint. Browse to the file, click the 3 dot menu for the file, click details, scroll down the details pane to find the document web path. Copy this url into Power BI as shown in the video.
I was struggling to connect the share point file to PowerBI but after watching this video it was done. Really nice video and thank you Avi for your live example.
Thank you, it helped a lot! Pity that Microsoft didn't separate reading Excel from SharePoint into a separate option in Get Data, as currently it is not intuitive at all, and I believe it is a very common task
@4:35 If you click on "Binary" there it will lead you directly to the file you need, from there you need to click on "Table" and you will get exactly what you need!
Using the Web import method and specifying the Excel file, how do you setup scheduled refreshes to pull in any changes made to the excel file. This is from the point of view of self-hosted PBI Report server, not Power BI Service! ? When in PBI desktop you get the option to login with organisational/microsoft o365 account. but that options isn't available when setting up the data source in PBI RS.
Amazing video!
Thank you, mate.
For the ones looking for a way to import a file located in sharepoint ( in a different folder than "Documents") go directly to minute 05:42.
Excellent video. Your delivery of information is very clear. I do hit one problem when trying to load data from a Sharepoint list, however. If the list field contains a name that comes from the Active Directory Global Address List, it returns the person's GAL ID, e.g., 1054 , not their name.
I am also wondering how to convert and show the name displayed on the Sharepoint list. Please let me know if anyone knows how to change those columns.
Hi Avi!! Thanks for the video. I was able to trouble shoot and connect to one of the files in Sharepoint. Next question I have is - How can I have this fiile on Auto refresh? I have shared the file online with my stakeholders and would like PBI to show real time data as soon as the file gets updated. Thanks!!
Hi, There is schedule refresh option available in Web version that you can use, it has option to refresh 7-8 times per day.
Hi Sailee... Do you know how to activate the auto refresh?
@@angelicalozano7085 refresh is set on the dataset. Check your license, though. I don't think the free version allows for it. Pro gets you some. Premium or PPU allows more, such as merges and references in the editor. As things change over time, please verify with the current MS licensing.
This video saved me. Thanks so much for clearing up the jump to combine on SharePoint Folder data sources. When I was trying to refresh data it was breaking because I didn't use the method you showed to exclude all the junk I didn't want from the site so I would get no-key errors.
Thanks Avi! I really appreciate the thought you put into this video. Not all creators take the time to reflect and think about the specific problems newbies like myself could run into! Great video. Keep up the good work! :)
Can you export the transformed data you built on Power Query to Sharepoint List using Power Query and set auto refresh timer?
thank you very much. your video helped me to solve the problem while reading a sharepoint folder in excel using power query.
Glad to help Paolo. Power On!
Thanks for this video. Got a question though - how can I filter data before its loaded to report from sharepoint list. As we know there is a limit of 5000 that we can load from SP so we would need to filter it.
Hey Avi, watching your video in 2022 and it helped me a lot! thanks for sharing!
Glad you found it useful. We are having an exciting event going on--> Get Your Free Pass 🎟️ at lnkd.in/fw-XvmC ^RM
Thank you for this video. I am very new to Power BI and connections. Does this mean when you connect directly to the list or folder and you create dashboards, it updates automatically? More like a real-time data?
Importing data from sharepoint is a very nice first step to get your Power BI dashboards/reports automatically updated. A next step would be to configure the updates frequency in Power BI service. Take into in account that for doing so you need a paid account.
Thanks Avi. Very clear on the process. I am still facing credentials issue though. Do we need access to the root itself? I just have access on one of the sub-folders where my excel input file resides.
Hello! Thank you so much for the video. It works. However, I have a report published and it is automatically refresh but it seems to have problems refreshing the Sara form the folder because it is attached to my user. Is there any way to fix this ?
Hi, thanks for the video!
What happens if I want to select csv files from sharepoint ?
Excellent many thanks very clear for a Frenchy !!!
Hi Avi, nice video. Would be great great if you could show how does this work once published to Service. Any specifics / tricks? Is gateway needed or not?
good question!, hopefully he answers soon!
Thanksss so much for sharing this, I was searching for how to fetch SharePoint excel with no success this helped me a lot
Thank you THANK YOU THANK YOU!!!!!!!!!!!!!!
Spend far to much time trying to get SharePoint Folders to work but in the end your explanation allowed me to achieve what I needed.
What would be great is if you could show the same data gather but from a DataFlow in the Services rather than in the Desktop. This being my ultimate aim.
Thanks Avi Power ON!
Andrew
Avi, I have managed to get this into a DataFlow.
Thank again for the help, you've made my day!
Andrew
Great Video thanks!!! Have you covered PowerBI errors by any chance? I constantly get them yet it doesnt seem to affect anything.
Great suggestion!
To combine files they must have same header row or you can combine files with different number of columns and headers?
Hi! I can't find a better option than you, I searched all over, but you make a good explanation! Can you please (really!), help to get the URL from images in a folder from Sharepoint to PowerBI?
Because if I follow the same steps as this video, it shows me an error, that it doesn't support JPEG, PNG, etc.
Thanks
Hi, Excellent work on it. May I ask if can I connect to someone's sharepoint folder that has been shared to me including the sub-folder and sub files. Because here you have query it successfully as it is your own sharepoint folder but what if it is not your sharepoint folder? Makes sense?
Additional on it, I want to query also the version history of the sharepoint folder and files which I do not own but has just shared to me. Thanks!
Hi Avi ! Great resource ! I have followed your advice but I am still having trouble connecting our Sharepoint Online Excel document to the Power Bi, we keep getting an error message "Access to the resource is forbidden", do you have any tips of suggestions please !
Stuck there too! Could you solve it?
you my man are a living legend! been looking for this and you explained and showed it CLEARLY!!
Wow! Thanks for that wonderful compliment mate! ⚡Power On!⚡ / Avi
★ Subscribe and Join me LIVE for Talk Power BI Fridays ruclips.net/user/PowerBIProlive ★
awesome subject , great and detailed content , thanks
Hello Avi! Awesome presentation. I have a real problem when connecting to a sharepoint online List. The data provided in the columns after making the first query looks like "asdf" the text inside isn't shown. What can I do?
Can you help??
Thank you for this video! What happens if I need to add more files in the share point folder selected in your example? Will they be combined automatically with the ones already there or I have to repeat the selection process all over again? I find it weird that we cannot just point out the full folder path in share point like we do with local folders.
I think that if the files you want to combine are in same folder, you will be able to combine them. Take into account that when you are inside power query you can combine/append as many tables as you want.
Hi Avi, I can't thank you enough for this great video mate. Trust me, I was just thinking about to ask you yesterday arvo to post a video on these 3 types of data sources - SharePoint folder, SharePoint Online List & SharePoint list and that's exactly when I got an intimation on my mobile that you've done this video. Nowhere had I found such a demarcating explanation, not even on Microsoft website! Thanks a million mate and as the saying goes.. "Sow Saal Jiyo" and a Happy Diwali. Kind regards, Bhoga
After connecting with sharepoint, does the data updated automaticly or do i have to keep clicking refresh? Can we make it update all the time?
Creating reports from stuff in SharePoint is always an ask. This is so helpful.
Excellent tutorial, worked perfectly for me. I implemented directly as a Dataflow in the Power BI service and the same method worked perfectly.
EXCELLENT VIDEO THANK YOU!
Very helpful and easy to follow instructions. Thanks a lot
Hi Hussain S,
So nice of you to leave a positive feedback, Hussain. Means a lot to me.
⚡Power On!⚡ / Avi
★ Get Your Questions Answered LIVE on TalkPowerBI Fridays www.learnpowerbi.com/talk ★
Singh is king ❤ thanks for the info man very clearly explained
And what if the report created in the power bi desktop and then uploading that report to sharepoint , will it reflect the current data after every refresh ?
How to set the gateway cluster for this to setup schedule refresh?
exactly what I needed, thanks a lot
Great job explaining this sharepoint procedure! Helped me a lot! Subbed!
Awesome, thank you!
Thank you for that tutorial, but main thing for me stays the same - i donk know how to get dashbord refrashed on local company server with power bi dashbords :(
And my personal specific is that i am connecting to a lical SharePOint List (not online because sharepoint list online does not have possibiliti to refresh by schadules )
So how it shoud be done ?
The first method: You combined several Excel files from a Sharepoint folder. What if those 3 excel files have different columns and data? Will it make 3 seperate queries for it?
I'm getting data from a SharePoint Excel File. This works fine on power bi desktop but when I publish, my azure credentials don't work, how do you properly set it up on Power BI Online?
Hi!" Did you get to fix tthis?
Nice video and your explanation is excellent
Thank you very much Avi.
Hi Avi, thanks for this!
I've built reports based on a local file. Now I uploaded the file to SharePoint but when trying to change the Data Source in PowerBI Desktop my credentials fail. I just wanted to know if what I'm trying to do is something doable regardless permission issues.
Thank you!
Marianne from Team Avi. Sorry Avi, was not able to get to your comment. If you're still stuck and need help we would recommend submitting the question to our LIVE TalkPowerBI Q&A Session www.learnpowerbi.com/talkpowerbi#qa
Hi, thank you for the great video. I need SharePoint folder to practice, can you please provide me?
Avi, thanks for the video. I was finally able to connect to my Sharepoint. Perfect!
Hi Edward Alarcón.
Woohoo glad the video helped you.
⚡Power On!⚡ / Avi
★ Power BI Complete Tutorial: ruclips.net/video/AGrl-H87pRU/видео.html ★
★ Get Your Questions Answered LIVE on TalkPowerBI Fridays www.learnpowerbi.com/talkpowerbi ★
I used these instructions to connect an Excel file, hosted on SharePoint, which seems to have worked fine. However, my data are not updating when I click "refresh"....Not sure what I'm doing wrong....
Thank you!
You're welcome!
Hi Avi, Love the Video ans it is working:) I have another issue with the BI Sharepoint Connect,aybe you can Help me.
I have a Sharepoint Bibliothek with document's in SUB folders, all Documents have Meta Data Like Responsible Person, valid areas and so on. If i now try to collect that Data with in Bi IT only show's Numbers instead of the Responsible Name and IT Shows only "list" by assigend areas.
How do you get back to the Microsoft Account login? I picked the wrong one and now I can't correct it.
Did you find out? Had the same problem here
Anybody found out how? :(
Hi Avi! Do you have any resources or help on doing this same process in Power Query Online? I have an excel table that is in a sharepoint folder that I'm trying to add to my dataflow but I just keep getting 'Invalid Credentials' errors.
Recently I came to watch your videos and I realized it’s much better than the one I used to follow. This video was just spot on you are amazing, Period. Thanks Arigato-!
Hi Tomoya Tsuruta,
Thank you for the amazing compliment! Glad this video has helped you in learning Power BI.
⚡Power On!⚡ / Avi
★ Get Your Questions Answered LIVE on TalkPowerBI Fridays www.learnpowerbi.com/talk ★
Thanks Avi. I'd like to load each of those Binary rows into a separate table rather than combining them into one single table because they all have different contents (columns and rows). I have saved all these tables in one path in a SharePoint. How to da that?
I do not see the "Copy Path" option in "Info." I wonder if the location of that option was changed or removed.
Hi
Thanks for the video 😊
Is there any way to connect power BI to .mpp file that’s the extension for Microsoft Projects?
Really helpful, thanks for the effort!
Glad it was helpful!
How to create modern SharePoint site analytics report using PowerBI?
Hi Avi - how would one set up the SharePoint as a data cluster in the enterprise data gateway when using both an Oracle source and SharePoint folder or file? Thank you
Hello, thank you very much for the video.
Do you know how to get the metadata from Sharepoint lists with PowerBI?
Hola, muchas gracias por el video.
Sabes como obtener los metadatos de las listas de Sharepoint con PowerBI?
Thank you very much. This save me a lot of time that I use to spend on manual refresh.
This is an amazing video!! Thank you so much for this
Glad you liked it!
thank you for your valuable video. this helped me a lot
Am glad you found this useful Josue. if you have any questions you can get them answered in our LIVE TalkPowerBI Q&A show.
👉 www.TalkPowerBI.com Or Join our LearnPowerBI Private Community
👉 web.learnpowerbi.com/waitlist-invite/
^RM
Thanks Avi... You saved my life
How can we refresh sharepoint excel from power bi sercies?
Marianne from Team Avi. Sorry Avi, was not able to get to your comment. If you're still stuck and need help we would recommend submitting the question to our LIVE TalkPowerBI Q&A Session www.learnpowerbi.com/talkpowerbi#qa
Brilliant video, Quick question, is it possible to check the number on uploads/downloads on a SharePoint Site using PowerBI
Hey Solvex, Can you elaborate a bit.
With Uploads do you mean, you just want to get a count of the files uploaded to a SharePoint folder?
And Downloads is how many times the file was downloaded (this may not be easy to get I think).
Power On! / Avi
Hi Avi, yes. I would like to see the number of times all the files in different folder are downloaded or when someone has uploaded to a folder
Thanks for the video. The thing is when you connect a sharepoint folder, it doesnt give you each of the fields to use in the report itself...it gives you generic things like 'type'
I have a question, If i decided to use this connection, will my dashboard gets refresh even though my computer is on sleep mode or off?
Thanks!
Welcome!
Incredible video
Thank you. Am glad you found this useful. if you have any questions you can get them answered in our LIVE TalkPowerBI Q&A show.
👉 www.TalkPowerBI.com Or Join our LearnPowerBI Private Community
👉 web.learnpowerbi.com/waitlist-invite/
^RM
thnx man helped me a lot for work !
Glad I could help
Hi.. I posted a question on another video of yours but I think this is more relevant. I have the same SharePoint file connected to two different pbix file. I created visuals on one, copy and paste the visuals on the other pbix file. Usually it works for other datasets.. but it didn't work on files connected to SharePoint. I also tried to copy the advanced editor data in query editor to the other pbix file. Yet it didn't work. Can you please help?
Thanks so much Avi, it helped me to resolve one of the issues. Keep up the good work.
This was quite helpful. THank you Avi and keep it coming.
Thanks for your video. Finally, I was able to connect to many shareporpoint folders in one report but any time that I enter on it the report ask me for my credentials, it's normal? I put my Microsoft account but any time I need to do it?
Very helpful tutorial. Thanks for this.
Hi!!! Nice to meet you :)
I need help with an issue connecting to Sharepoint online List. Could you help me? Please, I'll appreciate it.
It seems that the connection is Ok, according to this video. I refresh the power BI but the new information doesn't appear in the power BI, I have only the information when I did the connection, since that day my power BI doesn't actualize although I Refresh All the power BI by myself.
Thanks for the help
Regards
Hi, would it be possible to explain how to CHANGE the source to SharePoint Folder or File or OneDrive? Having tried many times so far, we got various errors. Thanks a lot.
Thank you! You saved my live by this video :-)
This is such a great tutorial!
Glad you think so!
Hi, Thanks for the video. I was able to connect to sharepoint from power query and prepared my report in excel through power pivot. But when I am sharing it with other user within the same group, they are getting refresh error? Any help?
Really Great Stuff!!!
Thanks for the feedback
Sharp !!! Thank you !!!
Hi Avi,
Thanks for the video was very helpful but I could not get it work with for my sharepoint. When I pass in the root sharepoint URL and connect with the Power BI Sharepoint connector I get the following error:
Details: " We found extra characters at the end of JSON input"
Have you encountered this before / know how to get around this? Thanks
Kevn
Thanks a ton, well explained. Can you create one for web API, Its prerequisites to source data for power BI using API
Thanks so much! I was lost!
Glad I could help!.Thank you for your feedback. If you'd like to learn more about Power BI , here is a link about our structured course on this Webinar
👉 web.learnpowerbi.com/waitlist-invite/
^RM
Saved my life again thanks so much!!
amazing! thanks bunch, can we combine this approach to incremental? lets say im sending reports (same layout) everyday to a SP repo and I would like to use those files to feed incremental, is that possible?
Simply Brilliant! thanks Avi.... BI Saviour you are!
I use this in Power Query to create a link to a file in Sharepoint site. The issue is it works but when I add files or rename them on the Sharepoint side and do another query to the Sharepoint folder to a file it keeps giving me the list of file names when I did it the first time. I do not get an option to refresh the view so I can see the new files as well. I tried Refresh All and then tried a new query to the same Sharepoint Folder. Please help.
Do you use similar techniques to connect to a document library as when connecting to a list?
Marianne from Team Avi. Sorry Avi, was not able to get to your comment. If you're still stuck and need help we would recommend submitting the question to our LIVE TalkPowerBI Q&A Session www.learnpowerbi.com/talkpowerbi#qa
Thank you ~!
Hi Avi! Thank you very much for the video. How to import in PoweBI all the items including all the related versions of a SharePoint List if the versioning feature has been enabled for the SharePoint List? Sometimes it might be helpful to get and show the data of the previous versions for all the SharePoint List items. I managed to import the latest version only for all the items, but I haven't yet found a solution for the past data of the same items.
Saved my life!! Thanks!!
Super 👌, Thanks for the video Avi! 😊
My pleasure 😊
Hi Avi. Power BI PRO is required for users to view reports and charts on a sharepoint site.
7:26- Sharepoint List