I am trying to Build Cnves App to integrate with Power Bi to be able the User to update data in SQL DB.
I added Edit Form for connecting with Azure SQL DB and add required fields like Price and Comment (where Comments shall be updated) and Price will be Update form Items formula as below to show selected values from Product ID;
issues I'm facing are
1. The error message is 'Invalid formula. Expected a value compatible with 'DataSource'.
2. when I review it is said item not display
Solved! Go to Solution.
Hi @Mona1 :
Could you tell me:
What is the specific operation you build canvas app to integrate with Power Bi? Could you elaborate on it?
There are many reasons will cause “No item to display”, such as:
Case1:The record that specified in the form’s items attribute does not exist.
Case2:The data source of the record specified in the form’s items property does not match the data source of the form
Case3:No record specified in the form’s items property.
According to your description, I guess your situation may fit the description of case2.
In order to solve this problem, I suggest you :
If you still have any problem, don’t hesitated to let me know.
Check out the on demand sessions that are available now!
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Features releasing from October 2020 through March 2021
Check out the Power Platform Community Highlights