Forum Discussion
Power Apps Integration - Calling column values with PowerBIIntegration.Data
You might be mixing a couple of slightly incompatible concepts. SQL Server Analysis Services are multidimensional cubes - they are not databases. Dataflows are flat csv (well, Parquet) files. If you want to connect to SSAS from PowerApps you will have to run a MDX query that pulls the required data into a flat format that you can then use into a gallery.
I have not been able to connect directly to this in Power AppsCan you please elaborate? What have you tried and where are you stuck?
So in the canvas app editor, it is possible to add a new data source, and there is an option to connect to a sql server. I have the server details, and the admin assures me that this database is shared with our entire organization, and I can confirm connecting to it in a fresh Power BI report in PBI desktop. With admin assistance, we tried connecting and get a
So I thought, surely I could use a fresh dataflow in Power Apps, since dataflows offer a connection with SQL Server Analysis Services. I spoke with an admin, and the connection to this database was shared with our defualt power apps environment. But when I click on it, the next screen is blank with a progress wheel that spins on and on forever.
You might be mixing a couple of slightly incompatible concepts. SQL Server Analysis Services are multidimensional cubes - they are not databases. Dataflows are flat csv (well, Parquet) files. If you want to connect to SSAS from PowerApps you will have to run a MDX query that pulls the required data into a flat format that you can then use into a gallery.
Thank you, you are correct, it seems I was confusing those concepts.