Embedding Power BI into D365 and Power Apps Forms

Power BI
1

Hi Everyone,

I’m working on the new Power BI integration. exactly what is shown in this youtube video.

Inside Power BI Report component has a checkbox called “Bind to table column”. It required a JSON code to be added in
The code i used:

“Filter”: “[{"$schema":"basic","target":{"table":"accounts","column":"cr065_abbausid"},"operator":"In","values":[$a],"filterType":1}]”, “Alias”: {“$a”: “ABB Aus ID”}}

The overall integration works fine. I can add reports and datasets to the solution. The only (major) problem I have, is to bind the report to the current table (matching the Cr065_abbausid)

Can anyone help/tell me what is the problem? and fix my code?

Thanks in adance!

2

Hi @clawintal did you follow the syntaxis for the PowerBIFilter

{
	        "Filter": "[{
	                \"$schema\":\"basic\",
	                \"target\":{
	                        \"table\":\"table_name_of_power_bi_dataset\",
	                        \"column\":\"power_bi_field\"
	                },
	                \"operator\":\"In\",
	                \"values\":[$a],
	                \"filterType\":1
	        }]",
	        "Alias": {
	                "$a": "field1_name_in_powerapps_to_filter",
	                "$b":"field2_name_in_powerapps_to_filter"
	        }
	}
  1. If you put the whole JSON string in one line it will work.
  2. Case sensitive: Review any misspelling the table name or column name
3

Hello @clawintal. Due to the length by which this post has been active, we are tagging it as Solved. Thanks to the contributors of this post. For further questions related to this post, please make a new thread. Feel free to reopen this thread if you anyone would like to answer the pending inquiry above.