Thank you so much. It's very helpful and I can link file from 1Drive to Power BI now. One more problem is how to apply this technic for get files from 1Drive folder instead of one single file. Please help advise.
@solutionsabroad It looks like Onedrive has now changed the format and all my connections have stopped working. I am afraid it is not following your example anymore. The URL is different, the word "embed" is missing and the athkey is not there. Do you have any workarounds? Thank you in advance
Thank you very much, until now I had not been able to connect PBI with my files in Onedrive. With your explanation it has been perfect. I have a question, can I do the same procedure to connect a PDF to PBI from Onedrive? Greetings from Asturias - Spain. How can I do to connect a folder that contains several files? Saludos desde Asturias - España.
Hi there, great question! At the moment the only way I know how to is if there's an underlying SharePoint site linked with your folders. From what I know one drive for personal isn't officially supported anymore
Hi there! You can't do it directly from SFTP, but you can create a Power Automate that lets you push the data from SFTP into somwhere Power BI can reach!: www.linkedin.com/pulse/how-connect-microsoft-power-bi-data-sftp-ftp-marcos-fattibello/
I'm getting a notice which says 'Unsupported browser: Office uses new browser technology and works best in the latest browsers'. I've updated my firefox and edge, and have tried using both as default browsers. but still get the same notice
Hi Erick, unfortunately I still don't know of a way to do this, you'll need to set up a Data Gateway to make it work currently so you can pull the data from your local folder
how can i get multiple files from the Same folder in Onedrive? Because this way it shows only-one file. Thank you very much
Thank you so much. It's very helpful and I can link file from 1Drive to Power BI now.
One more problem is how to apply this technic for get files from 1Drive folder instead of one single file. Please help advise.
Hi. Great content! A question: how to connect to a folder instead in OneDriver personal? Like for list the existing files and choose which one to use?
@solutionsabroad It looks like Onedrive has now changed the format and all my connections have stopped working. I am afraid it is not following your example anymore. The URL is different, the word "embed" is missing and the athkey is not there. Do you have any workarounds? Thank you in advance
Hi,
Embed option not available in my onedrive file..
Can u help
Thank you very much, until now I had not been able to connect PBI with my files in Onedrive. With your explanation it has been perfect.
I have a question, can I do the same procedure to connect a PDF to PBI from Onedrive?
Greetings from Asturias - Spain.
How can I do to connect a folder that contains several files?
Saludos desde Asturias - España.
WOOW! You ROCK! Have tried this many times with no success!
Good to know. However there is an easier way to do that. You just do Get Data from Sharepoint and specify the file path down to "\layout".
Hi works great with personal onedrive. Do you have a work around for onedrive business?
really great. you save my time. thanks for sharing.
Great tutorial!
But will the Power BI dataset update automatically when the Excel file is edited or updated?
Awesome. Can I also connect to a OneDrive folder?
I'm interested in it either.
Hi there, great question! At the moment the only way I know how to is if there's an underlying SharePoint site linked with your folders. From what I know one drive for personal isn't officially supported anymore
You totally saved my life.........THANK YOU
Very interesting, thanks !
Is there any way to get data from SFTP source to power bi ?
Hi there! You can't do it directly from SFTP, but you can create a Power Automate that lets you push the data from SFTP into somwhere Power BI can reach!: www.linkedin.com/pulse/how-connect-microsoft-power-bi-data-sftp-ftp-marcos-fattibello/
wow! wow! wow!
Hmm I don't have the embed option on myside. Anyway you can use another way to get the link?
thank you and appreciate. If there is a more simplier method much better.
hello, i couldn't find the "Embed " word in Onedrive
Hi Issam, sometimes your admin can disable certain features for security purposes, check with your IT Admin if this is the case
Amazing ! You are just a Rockstar
I'm getting a notice which says 'Unsupported browser: Office uses new browser technology and works best in the latest browsers'. I've updated my firefox and edge, and have tried using both as default browsers. but still get the same notice
Hey Joseph, sounds like your Javascript is disabled in one of your browsers, have you tried enabling it?
thanks
You're welcome!
work like a charm
Does this method works with Power BI Service also? Like scheduled refreshes ?
Hi there, yes! This is one of the reasons we use online sources like OneDrive, to enable automated, scheduled refreshes
@@SolutionsAbroad great
Hi, when download I only get 9.999 lines. Is there any limit?
Thanks ;) very helpful
Thank you very much
You are welcome
Interesting! How can we get all the files from a folder in One Drive Personal
Hi Mirza, unfortunately I still dont know how to do this either! I'll have a think about this and get back to you!
min 5:26 get data from a folder??? please
Hi Erick, unfortunately I still don't know of a way to do this, you'll need to set up a Data Gateway to make it work currently so you can pull the data from your local folder