Forum Discussion

Kristian71's avatar
Kristian71
Frequent Visitor
1 year ago
Solved

Onedrive Personal to Power Query

It seems like MS have done a change when you want to connect Power BI desktop to an Excel on Onedrive Personal. I have a 365 family subscription and want to connect an Excel on my Onedrive to PBI an...
Need Help
Kristian71's avatar
Kristian71
Frequent Visitor
1 year ago

Well, going down that path, it wasn't really an answer to my question, as I specifically ask into OneDrive and the authorization and source. 
It`s all about getting The connection to The online OneDrive .

v-prasare's avatar
v-prasare
Community Support
1 year ago

Use the Web Connector in Power BI Desktop to connect directly to the OneDrive Personal link. the OneDrive for Business connector in Power BI should work to connect your OneDrive Personal Excel files in the cloud directly.

 

let me know if this helps you resolve query?

 

 

Thanks,

Prashanth Are

MS Fabric community support

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

  • v-prasare's avatar
    v-prasare
    Community Support
    1 year ago

    Kristian71, As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by our super users for your issue worked? or let us know if you need any further assistance here?

     

     

    Thanks,

    Prashanth Are

    MS Fabric community support

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

  • Kristian71's avatar
    Kristian71
    Frequent Visitor
    1 year ago

    Thanks v-prasare, but no luck.

    When I use the web connector it will not connect, it remain stuck in the connection window:

     


    Searching for a dedicated onedrive connector, none is available:

     

    I've tried the web connector as well using a direct link to the Excel, but that is usually not required, and I would normally add it either as a parameter and/or a alternate url in M.