Forum Discussion

harry1848's avatar
harry1848
Frequent Visitor
3 years ago
Solved

Power Apps Integration - Calling column values with PowerBIIntegration.Data

Description:  I have a Power BI report with a Power Apps integrated visual (create new NOT use existing). On the first page of the report, I have a series of filters and slicers that reduce my data ...
Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago

    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.

lbendlin's avatar
lbendlin
Super User
3 years ago

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.

harry1848's avatar
harry1848
Frequent Visitor
3 years ago

Thank you, you are correct, it seems I was confusing those concepts.