Plaza 365
Plaza 365

No results found for your search

RegisterLog in

1

Power Query – Creating New Parameters

Visit article

#parameters

#query

Power Platform - General

Category

Feb 26, 2025

Published date

Text

Article Type

AI Summary

  • The article discusses the importance of using values to point to data when fetching data into Power Query.
  • It highlights the good practice of using parameters for values to make queries reusable.
  • The article mentions the issue of the missing option to create a new parameter when connecting to a csv file on the web in Power Query.
  • The fix for the missing new parameter option is to allow parameterization in data source dialogs in Power BI desktop options or Power Query View ribbon for Power BI and Excel.
  • By enabling parameterization, users can now easily create new parameters in Power Query.
  • It is recommended to always give parameters a type rather than leaving it on Any for compatibility with features like Power BI deployment pipelines.
  • The article concludes that despite being a small feature, the ability to easily create new parameters can greatly improve workflow efficiency.
  • The author emphasizes the importance of using parameters from the start in Power Query.

Registered users can view the full text for FREE!

Sign In Now!