You’re offline. This is a read only version of the page.
Announcements
Hello everyone,
I try to do a demo to write back to the SQL Server source with PowerApp in a Power BI Report. Actually it's exactly like in this example:
https://www.youtube.com/watch?v=LxuRzj0X348
I try to do it with AdventureWorksDW2017 and the table FactSalesQuota. In Power BI I pass through the following fields from the table FactSalesQuota:
In PowerApp I did a gallery (shows the Power BI values) and added an edit field (connected to the SQL Server datasource FactSalesQuota). There I tried to make a connection to the gallery by putting as item myGallery.Selected
But I always get the error message "Invalid Formula. Expected a value compatible with 'DataSource'". Yes, I searched the forum and I didn't understand it at all.
How do I pass the right fields to the PowerApp that it can display the selected values? I appreciate any help
Hi @Anonymous ，
I have made a test on my side, and also have the same issue.
The cause of issue is that date column is divided into Day, Month, Quarter, Year columns. However the Original SQL Data source is still data column. So the error show the items isn’t compatible with 'DataSource'.
The work around is changing “Date Hierarchy (Defaults)” to “date” by right-clicking when you select Fields to PowerApps Data, so that the date column will not be divided.
Then just keep the previous step, it will work fine.
Best regards,
Sik
Share
Report
All responses (
Answers (
793
