Plaza 365
Plaza 365

No results found for your search

RegisterLog in

9

Power Query – Creating New Parameter Made Easier

Visit article

#parameter

#query

Power Platform - General

Category

Jan 10, 2025

Published date

Text

Article Type

AI Summary

  • The article discusses the importance of using values to point to data sources when fetching data into Power Query.
  • It highlights the good practice of using parameters for values in queries to make them reusable.
  • The article mentions the issue of the missing New Parameter option in the dialog box when connecting to a csv file on the web.
  • The fix for this issue is to enable parameterization in data source dialogs in Power BI desktop options or Power Query View ribbon for Power BI and Excel.
  • Enabling parameterization allows for the selection of New Parameter and entering details for the new parameter.
  • 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 the small feature of the drop-down for creating a new parameter makes it easier to follow the advice of using parameters from the start.
  • Despite being a small feature, the convenience of creating a new parameter with a few clicks can encourage users to implement parameterization in their queries.

Registered users can view the full text for FREE!

Sign In Now!