cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gusly
Helper II
Helper II

Using Power BI Desktop and connecting to file from OneDrive Personal

I'm wondering how to connect to a OneDrive Personal file using Power BI Desktop (to be able to publish reports/dashboards and then keeping them up to date as the file on OneDrive changes). It is possible through the web app and it also seems quite easily done when using OneDrive Business (how to is mentoined in some other threads, for example here), but I can't get it to work using the personal version.

If anyone has done this or can help me out getting the proper url for the file, please help me out. Thanks.

1 ACCEPTED SOLUTION
ashishrj
Power Participant
Power Participant

@gusly Yes this only works with One Drive for Business and I have tried and tested using new Excel 2016 and works well !

You can now publish your workbook content to Power BI, directly from Excel 2016! Once your workbook is published, you can keep working on it in One Drive for Business. Power BI automatically refreshes when you make updates to your workbook without the need to schedule refresh 🙂 Hope this work ! For more info find link here.

View solution in original post

2 REPLIES 2
ashishrj
Power Participant
Power Participant

@gusly Yes this only works with One Drive for Business and I have tried and tested using new Excel 2016 and works well !

You can now publish your workbook content to Power BI, directly from Excel 2016! Once your workbook is published, you can keep working on it in One Drive for Business. Power BI automatically refreshes when you make updates to your workbook without the need to schedule refresh 🙂 Hope this work ! For more info find link here.

View solution in original post

I understand that this will publish to PowerBI.com but is there a way to publish to Power BI desktop? I just upgrade Excel to 2016.

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Kudoed Authors