cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Server Analysis Services on-prem as data source

Please add SSAS on-prem as data source

 

Thank you!

Status: Under Review

@archanan to update status.

Comments
Microsoft Employee

Interesting request. How do you envision using SSAS from PowerApps? Are you talking Multi-dimensional or Tabular AS?

 

Do you have reporting scenarios in mind?

Level: Powered On

Hi faisalmo,

I would like to expose data retreived from Tabular AS model in order to support decision/action and data entry that will operate on a separate sql db.

 

Thank you,

Roberto

Power Automate Staff
Status changed to: Under Review

@archanan to update status.

Anonymous
Not applicable

I think this would be handy so you could use a Powerapp as a reporting tool on SSAS tabular. It would require you being able to somehow pass DAX from the app across the gateway to the tabular instance but it would be worthwhile.

Level: Power Up

This would be useful.  Any timeframe if/when it would be available

 

Anonymous
Not applicable

Not just on-prem, also Azure SSAS cubes and Azure Datawarehouse should be supported. Actually this is probably easier as it is all in the cloud.

 

A classic problem is one we have at the moment - users need to enter comments against financial line items or comments about their budgets.  This information is stored in cubes, however recording comments against each line is problematic.  We accomplish this with excel currently - download the data into a spreadsheet pivot table, then upload to a database using the reporting lines as a reference. Powerapps would be perfect for this, instead we have to do it offline or build a custom web application.

Level: Power Up

I second, third, and fourth this idea. 

 

I'd love to replace some macro enabled excel spreadsheets with powerapps, but those spreadsheets connect to SSAS, not SSDB

Level: Powered On

Any update, we really need to be able to read data from our SSAS Tabular models and use Power Apps to allow users to enter comments or information about the various items and rows.  


@francorg wrote:

Please add SSAS on-prem as data source

 

Thank you!