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
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?

 

speedramps, Thanks for your promt response 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

So The point is that I want to publish to the service, so I need to connect from desktop to OneDrive online, so the connection can be utilized in the service.

installing a personal gateway and create a connection to my pc is also not an option.

  • speedramps's avatar
    speedramps
    Super User
    1 year ago

    Yes ... as you say, it is your bad.
    You specifically asked to "connect Power BI desktop to an Excel on Onedrive Personal."

    You were given the correct answer.

    Please have the courtesy to accept the correct solution and raise a new post wuith your new question.

     

    You will get quicker and better answers if you ask the right questions,

    and volunteer helpers might not feel they are time wasting.

     

    I am happy to help when the new post is fortcoming but I operate a one question per ticket policy and politely ask members to take care and attention when asking questions.

     

    Don't feel bad ... you will be gettng two answer for the price of none 😀

    Other helpers may help you with this one. 

    Best wishes 👍

     

    • 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