Power App visual data entry to SQL doesn't work with SSAS live connection

[kaarel]

It pulls in the correct data from the Power BI filters, but it doesn't auto fill the Power App Edit Form. 

When I use SQL tables based data model, all works perfectly fine. It is all based on a very simple table, with

2 columns: ItemID and Amount. When I switch to SSAS Multidimensional Live Connection, values come in correctly, but auto fill gives an error.

https://www.youtube.com/watch?v=LxuRzj0X348

Best Wishes,
Kaarel.

[v-juanli-msft]

Hi @kaarel 

Please make sure the Gallery(items property) and the EidtForm (DataSource property) are all connected to the same Data Source.

The error message should mean the schema does not match.

Basically, item property of EditForm control is the record from the tabled added under DataSource property of the same EditForm control.

For more information about forms, please check:

Understand data forms in Microsoft PowerApps

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.