Please add SSAS on-prem as data source
@archanan to update status.
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?
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.
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.
This would be useful. Any timeframe if/when it would be available
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.
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
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!