Forum Discussion
Solved
power query | parameter query to filter data by dates (year) from google bigquery database
hi, i get my data for period beginning 01 January 2015 from google bigquery as follows: Source = Value.NativeQuery(GoogleBigQuery.Database() {[Name="abc-stock"]}[Data], "select * from abc-stock...
This blog article describes the approach well, including a good M code example.
Passing Any Arbitrary Value From A Power BI Report To A Dynamic M Parameter (crossjoin.co.uk)
Set the parameter type to List of values. You will need to cover both scenarios (single value provided or multiple values provided) and change your SQL statement accordingly. Use Value.Is to tell one from the other.