Thanks for this. But does anyone else think it's completely ridiculous that we have to do this work around between two Microsoft Products? Shouldn't OneDrive be one of the primary data sources that PowerBI looks for?
My work peers and I have a suspicion that this was built by someone else and purchased by Microsoft and they just slapped a ribbon on it to say it's a Microsoft product. Not much of it functions as the other Microsoft apps do. SMH
Hello Sir. This trick works very very well !!! I still find a bit funny that we need a workaround to connect two products from the same brand. In any case, it works very well. Thanks for sharing this ! Greetings from Belgium 🇧🇪.
Excellent Information and thanks a ton for this video. I really appreciate your efforts for this and useful for many users who connect excels to Power BI. Thanks again.
Hi there I have some issues. I already get data source path from my one drive using web path and the after I publish to Power BI report server it wont connect to data source. What authentication should I choose? Windows or Basic? Thanks
I have a Power Bi question. Hopefully you will be able to answer. So i update weekly reports into PBI via Excel and i do the cleaning every week in Excel. Is there a way for me to do the cleaning once in PBI power query and then just upload the weekly unclean reports into PBI every week without doing the same cleaning? If so, how do i go about doing it step by step.
I finished building my project completely and was using dataset from disk e, but now I want to copy data to one drive without the trouble of rebuilding the report again, what is the solution?
Thanks for this. But does anyone else think it's completely ridiculous that we have to do this work around between two Microsoft Products? Shouldn't OneDrive be one of the primary data sources that PowerBI looks for?
My work peers and I have a suspicion that this was built by someone else and purchased by Microsoft and they just slapped a ribbon on it to say it's a Microsoft product. Not much of it functions as the other Microsoft apps do. SMH
Hello Sir.
This trick works very very well !!! I still find a bit funny that we need a workaround to connect two products from the same brand. In any case, it works very well. Thanks for sharing this !
Greetings from Belgium 🇧🇪.
EXCELLENT! Exactly what I have been spending so much time trying to figure out. Thank you!
Excellent Information and thanks a ton for this video. I really appreciate your efforts for this and useful for many users who connect excels to Power BI. Thanks again.
Great job. Fast and to the point.
Glad you enjoyed it
Exactly what I was looking for, thanks for posting.
YOUR ARE MY SALVATORRRRR, Thank u so much, really good video, so clear, so clever. Thanks mate
After publish the report, do i need to refresh on pbi desktop or it will be updated automatically?
This was very informative
Thank you so much ❤
Excelent! Thanks for sharing. Great job.
thank you very much for this tip.
Glad you enjoyed!
Hi there I have some issues. I already get data source path from my one drive using web path and the after I publish to Power BI report server it wont connect to data source. What authentication should I choose? Windows or Basic? Thanks
So useful. 👍 thanks
Thanks...it's so informative
Glad it was helpful!
Thanks!!!!
It worked, Thanks!
You are very welcome!
Doesn't work anymmore...
Thanks for tips
Thanks Jerrmiah for sharing this trick!
No problem!
Thank you sir
should have more upvotes.
To connect with oneDrive, we can select excel or folder connector and select onedrive folder or file inside PC
I have a Power Bi question. Hopefully you will be able to answer.
So i update weekly reports into PBI via Excel and i do the cleaning every week in Excel.
Is there a way for me to do the cleaning once in PBI power query and then just upload the weekly unclean reports into PBI every week without doing the same cleaning? If so, how do i go about doing it step by step.
Very useful info
Great work!
I finished building my project completely and was using dataset from disk e, but now I want to copy data to one drive without the trouble of rebuilding the report again, what is the solution?
Great - work. Thanks a lot!
Very insightful
Glad you enjoyed it
Thanks for wonderful trick
Any time
so here when i share the pbix file the people im sharing can access the data?
My url looks different and I have no ?=1 at the end. Why is that?
same here
Thanksssss
Does this work smoothly when you've made a complete dashboard with an imported Excel file?
Is it possible to connect Excel with Power BI online ?
Tks but why delete the very end of the path?
Neat!
I don't have Excel desktop app, just One Drive
I got this error Access to the resource is forbidden
Would someone explain why the '?web' had to be deleted?
FrFr 😳 Awesome as always!!! 🙏🫶