How can we improve Microsoft Azure Analysis Services?

Easy method for restoring/uploading existing Power Pivot/Power BI Desktop Models

One of the nicest features of on premise SSAS Tabular is the ability to ugrapde a Power Pivot model from Excel directly into SSAS. From what I've seen so far, this isn't easy in Azure since there isn't direct access to the server and file structure and normally the SSAS service account needs permissions to access the Power Pivot file's location.

37 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)

    We’ll send you updates on this idea

    MDMD shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    2 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Lee WhitneyLee Whitney commented  ·   ·  Flag as inappropriate

        Is it planned as part of this to allow PBI Desktop to edit the model directly? Why worry about this upload/restore, just work with the Azure model in the same way to work with the desktop model.

      • MDMD commented  ·   ·  Flag as inappropriate

        After playing with this a little more, you can get a Power Pivot model uploaded, you just can't use the Azure SSAS instance as your workspace server. Use an integrated workspace or a server (like a localhost installation) that you can give the service account access to the file. Once the model is in SSDT set the deployment server to the Azure SSAS instance.

      Feedback and Knowledge Base