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)
thanks for your input, lbendlin.
as this (sql in power bi) is still new to me, can u kindly show me an example (a dummy case will do)?
tks & kind rgds, -nik
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)