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.
"then what's the point of passing the data along (or using Power Bi at all)? You users may not understand what is happening." -What do you mean? I need to find some values and use those to submit a form. The data model we are working with is enourmous, and is stored in a SQL Server Analysis Services Database. I have not been able to connect directly to this in Power Apps, nor can I build a dataverse table via dataflow, which would enable me to use a model driven app instead of this current setup which is the Power App dataset-> Power App report visual ->Canvas App form submission.
The only way to use this data and submit a form(in this case its called a "project cost transfer request") is to start with a power BI report and use a canvas app imbedded. The passing of data with PowerBIIntegration.Data is the only way any values get into the canvas app controls (gallery or form). , and as I understand it is the limit of the canvas app integration technology.
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.