Reference a cell in Power Query for Excel or a parameter for Power BI
It can be useful when building queries with Power Query for Excel or Power BI to reference a value changeable by the user. Parameters are made for this, and work nicely in Power BI but less well in Excel where you would typically want users to edit a value in a cell. In this video I show both methods and when you might want use a certain one. I look at filtering, a data source on one's local computer and conditional columns which all have use cases to avoid hard coded values.
You can download the example files here: https://www.xlconsulting-asia.com/you...
00:00 Introduction
00:44 Create parameter from an Excel cell value
03:30 Conditional column
04:56 Get data from file/folder
05:20 Useful options
08:15 Manage parameters in Power BI
13:34 Manage parameters in Excel
Watch video Reference a cell in Power Query for Excel or a parameter for Power BI online without registration, duration hours minute second in high quality. This video was added by user David Benaim 04 April 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,937 once and liked it 42 people.