Nice video... Just one question, I tried many times to use the line bellow, but I always got empty folder message = SharePoint.Contents("lenny1-my.sharepoint.com/personal/XXXX_XXXXXX_com") Then I Tried to use get data with Sharepoint Folder, and I saw the source code that was created has at the end , [ApiVersion = 15] Then i go back to try the sharepoint.contents with the same source from sharepoint folder = SharePoint.Contents("lenny1-my.sharepoint.com/personal/XXXX_XXXXXX_com", [ApiVersion = 15]) And now is working.. Have any ideia why this is happening?
hello sir, thank you for your video. actually I have a concern: I tried to import a folder from personal ondrive to power bi w ithout success, I am still asking for your help. thanks in advance
Thanks a lot for this video Reza! This comes at the right time for me. A lot of our clients are moving towards power bi for their reporting. A common theme is that they receive monthly files from their vendors (imagine fleet details, travel expense reports, sales, etc.) as excel/csv. As of now, we would write a job where they could place these files on a folder and an SSIS job would fetch these files and place them into a sql table. However, after watching this video, I think it is possible to simply ask them to place these files - that they receive once a month/weekly - on a OneDrive folder as and when they come and have the folder connected to Power BI ! That way, we don't need to use our on-prem servers for anything! What do you think? Best, Apoorv
Awesome video, almost exactly the problem I'm having currently. However, you show it with Power BI Desktop. How would this work if I want to start fresh from Power BI Service/Cloud with a Dataflow? There's already a "SharePoint Files" data source but - as you showed - I can only use my OneDrive "base URL" that points to the root folder. I currently don't see how I can go from there to the sub-folder where my CSV files are ...
In the future if I get more files, can I add them into the folder and would that data get uploaded into Power BI or would it require manual process for every new data?
Hi Reza, I have 2 folders on SharePoint named as 'Current' and 'History'. Initially, I have loaded files from both the folders and combined the data. But in Refresh, I want to refresh data from the 'Current' folder only. I don't want to refresh 'History ' files. Can you please help me here? Thanks in advance.
When I paste in the sharepoint URL it doesn't display any folders, even though they are in sharepoint. There is no error and I can see the the same column headers as you do, but its blank. I have set global and dataset permissions to use my microsoft login credentials and am logged into Power BI with the same account. Any ideas? Thanks
Working now. I changed the Source step to Sharepoint.files...which gave all the files in Sharepoint and then changed it back to Sharepoint.Contents and suddenly it worked. 'API Version= Auto' was added when I did this, so the code is as follows: SharePoint.Contents("....url.....", [ApiVersion = "Auto"]).
Nice video... Just one question, I tried many times to use the line bellow, but I always got empty folder message
= SharePoint.Contents("lenny1-my.sharepoint.com/personal/XXXX_XXXXXX_com")
Then I Tried to use get data with Sharepoint Folder, and I saw the source code that was created has at the end , [ApiVersion = 15]
Then i go back to try the sharepoint.contents with the same source from sharepoint folder
= SharePoint.Contents("lenny1-my.sharepoint.com/personal/XXXX_XXXXXX_com", [ApiVersion = 15])
And now is working..
Have any ideia why this is happening?
Thanks a lot, you made my day :)
Perfect way to get away from the gateway and allow refreshes when the PC is not on! Thanks
Glad it was helpful :)
can you show howrefresh a dataset, that get's data from a local source requiring a gateway AND a sharepoint file?
hello sir, thank you for your video. actually I have a concern:
I tried to import a folder from personal ondrive to power bi w
ithout success, I am still asking for your help.
thanks in advance
Thanks a lot for this video Reza! This comes at the right time for me.
A lot of our clients are moving towards power bi for their reporting. A common theme is that they receive monthly files from their vendors (imagine fleet details, travel expense reports, sales, etc.) as excel/csv. As of now, we would write a job where they could place these files on a folder and an SSIS job would fetch these files and place them into a sql table.
However, after watching this video, I think it is possible to simply ask them to place these files - that they receive once a month/weekly - on a OneDrive folder as and when they come and have the folder connected to Power BI !
That way, we don't need to use our on-prem servers for anything!
What do you think?
Best,
Apoorv
Hi. That would definitely worth doing.
Awesome video, almost exactly the problem I'm having currently. However, you show it with Power BI Desktop. How would this work if I want to start fresh from Power BI Service/Cloud with a Dataflow? There's already a "SharePoint Files" data source but - as you showed - I can only use my OneDrive "base URL" that points to the root folder. I currently don't see how I can go from there to the sub-folder where my CSV files are ...
In the future if I get more files, can I add them into the folder and would that data get uploaded into Power BI or would it require manual process for every new data?
This process is automatic. in the future when there is a new file added in that folder, it will be automatically processed.
Thank you soooo much! I've been stuck for days until now!
Very well explained, Thank you for sharing this.
Hi Can we do something with files in google drive?
Hi Reza,
I have 2 folders on SharePoint named as 'Current' and 'History'. Initially, I have loaded files from both the folders and combined the data. But in Refresh, I want to refresh data from the 'Current' folder only. I don't want to refresh 'History ' files. Can you please help me here? Thanks in advance.
Hey Reza
Thanks for your videos. Is there any way to connect to a file (excel or etc.) that is located in the client's servers?
How if it's from Google drive folder ?
This is exactly what I needed! Thanks Reza x
and how do you connect to a folder that is not one drive business ???
Will this work with OneDrive Personal? Thanks!
When I paste in the sharepoint URL it doesn't display any folders, even though they are in sharepoint. There is no error and I can see the the same column headers as you do, but its blank. I have set global and dataset permissions to use my microsoft login credentials and am logged into Power BI with the same account. Any ideas? Thanks
Working now. I changed the Source step to Sharepoint.files...which gave all the files in Sharepoint and then changed it back to Sharepoint.Contents and suddenly it worked. 'API Version= Auto' was added when I did this, so the code is as follows:
SharePoint.Contents("....url.....", [ApiVersion = "Auto"]).
Excellent solution.
Awesome video. Thank you!!!!!!
Great video Reza. Thanks for sharing it!
😊👊
This is video is amazing :) I looked for long time for this solution, and this is exactly what I wanted. Thank you so much!!!
Glad it helps 😊
Very nice! Thank you for sharing!
Very helpful. Thank you.
Thanks for sharing it.
Good content, thank you!
Thank you very much.
gracias, saludos desde chile!!
Thanks a lot! 🙏
Thumbs Up Reza need more videos
Thanks you sooooooooo much !
You're welcome!
Dude you good
Thank you, I have seen alternatives where the just filter for folders containing a specific text. But this best solution I think
Thank you!
Thank you!