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.

58 votes
Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)

We’ll send you updates on this idea

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

4 comments

Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)
Submitting...
An error occurred while saving the comment
  • Lee 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.

  • MD 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