I am pulling data from inSQL using the SQL Query below:
SET QUOTED_IDENTIFIER OFF SELECT * FROM OPENQUERY(INSQL, "SELECT DateTime, [X],[Y], [Z], [A] FROM WideHistory WHERE wwRetrievalMode = 'Cyclic' AND wwResolution = 1000 AND wwVersion = 'Latest' AND DateTime >= '20210601 20:02:33.000' AND DateTime <= '20210607 20:02:34.000'")
I’m using this table in PowerBI and want [X],[Y], [Z], [A] & the DateTime values to dynamically change based on user input.
Any advice on this would be greatly appreciated. I am new to PowerBI and SQL.