Power BI API with Dynamics 365

Thanks so much Jing. This is great and helps a lot.

Looks like this puts me on the right track but not yet over the finish line.

When making a call without the variables de filter data element postingDate comes down in Date format like 31-12-2021.  The variables are formatted accordingly as shown below and further conversion in the urlString is not needed.

The single and double quotes around the variables have been switched: double quotes inside the single quote otherwise there is an error message " end of line missing comma".

With the above syntax I get the error message that the & operator cannot be used on text or date types. 

Is there a solution for this.

Once again, help greatly appreciated.

Best regards

Paul