In this video, Patrick shows you how you can use a parameter, within a Power BI report, to dynamically change the data in a report. This uses M Functions within Power Query and a second source that has the key values to pull. Then using a gateway to enable refresh.
LET'S CONNECT!
Guy in a Cube
-- https://guyinacube.com
-- http://twitter.com/guyinacube
-- http://www.facebook.com/guyinacube
-- Snapchat - guyinacube
-- https://www.instagram.com/guyinacube/
***Gear***
Check out my Tools page - https://guyinacube.com/tools/