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
-- [ Ссылка ]
-- [ Ссылка ]
-- [ Ссылка ]
-- Snapchat - guyinacube
-- [ Ссылка ]
***Gear***
Check out my Tools page - [ Ссылка ]
Dynamic Power BI reports using Parameters
Теги
Business IntelligenceBusiness AnalyticsAnalyticsGuyInACubeGuy in a CubePatrick LeBlancPower BIPowerBIbiMicrosoftparametersdynamic datadynamic parametersStored ProceduresSQL ServerMicrosoft SQL ServerExcelPower QueryM SyntaxM FunctionPower Query functionPower BI DesktopgatewayrefreshOn-Premises Data GatewayPersonal Gateway