How can we improve Power BI?

Power Bi Desktop auto refresh using Excel on OneDrive

If the Power Bi Desktop uses as a source an Excel file, booth on OneDrive it should not be necessary to use Personal Gateway

17 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Gianluca Casagrande shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    2 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Gustav commented  ·   ·  Flag as inappropriate

        I have to agree, just starting to look more at Power BI and I'm surprised by this difference between the Web-client and the Desktop-client! Why are they not aligned in this? I really would like to build reports on Excel in OneDrive/SharePoint through the more powerful desktop-client.

      • Casey commented  ·   ·  Flag as inappropriate

        I echo this request. It would be great to have a direct OneDrive for Business data source connection in Power BI Desktop. As I understand it, using the File data connector to point for a local file stored in OneDrive doesn't offer the sync/refresh benefits advertised for source files in OneDrive. The only way to do it in Desktop seems to be a roundabout way of getting the URL for a OneDrive for Business file from the web app, modifying it, and then using that with the Web data connector in Power BI Desktop.

        OneDrive for Business is an available data source in the Power BI Service online, and it would be awesome (and useful) to have it in Power BI Desktop as well so that we wouldn't necessarily need to use a data gateway.

      Feedback and Knowledge Base

      Ready to get started?

      Try new features of Power BI today by signing up and learn more about our powerful suite of apps.