Skip to content
BI Insight Logo

BI Insight

Business Intelligence and Data Visualisation

  • Home
  • About me
  • Contact me
  • Visit Data Vizioner Now
    • Data Vizioner
    • Data Vizioner Blog
    • Start Using Power BI Documenter Now

Search Results for: query parameters

Business Intelligence - BI, Power BI, Power BI Desktop, Power BI Desktop RS, Power Query, Quick Tips, Self-Service BI, SQL Server, T-SQL

Quick Tips, Power BI Desktop, Query Parameters, Part 4, Passing Power Query Parameter Values to SQL Server Stored Procedures

I have written 3 blogposts about query parameters in the past. Power BI Desktop Query Parameters, Part 1, Introduction Power BI Desktop Query Parameters, Part2, Dynamic Data Masking and Query Parameters Power BI Desktop Query Parameters, Part 3, List Output This is the fourth one in the form of Quick Tips. Here is the scenario. … Continue reading Quick Tips, Power BI Desktop, Query Parameters, Part 4, Passing Power Query Parameter Values to SQL Server Stored Procedures

Share this:

  • Click to share on LinkedIn (Opens in new window)
  • Click to share on Twitter (Opens in new window)
  • Click to share on Reddit (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on Telegram (Opens in new window)
  • Click to share on WhatsApp (Opens in new window)
  • Click to share on Pocket (Opens in new window)
  • More
  • Click to share on Skype (Opens in new window)
  • Click to email a link to a friend (Opens in new window)

Like this:

Like Loading...
August 28, 2020February 16, 2022M, Power BI, Power BI Desktop, Power Query, PowerBI, PowerQuery, SQL Server, Stored Procedure, T-SQL, T-SQL in Power BI Desktop Parameters, T-SQL In Query Parameters2 Comments
Power BI, Power BI Desktop

Power BI Desktop Query Parameters, Part 3, List Output

In the previous posts, here and here, I explained how you can use Power BI Desktop Query Parameters for many different use cases. Power BI development team added another cool feature to Power BI Desktop on July 2016 which is the ability to add a List Query output to a query parameter as it’s “Suggested … Continue reading Power BI Desktop Query Parameters, Part 3, List Output

Share this:

  • Click to share on LinkedIn (Opens in new window)
  • Click to share on Twitter (Opens in new window)
  • Click to share on Reddit (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on Telegram (Opens in new window)
  • Click to share on WhatsApp (Opens in new window)
  • Click to share on Pocket (Opens in new window)
  • More
  • Click to share on Skype (Opens in new window)
  • Click to email a link to a friend (Opens in new window)

Like this:

Like Loading...
September 19, 2016February 16, 2022Create List From Table Column, Parameters, Power BI, Power BI Desktop, Power BI Desktop Query, Power BI Desktop Query Parameters, Power BI Desktop Query Parameters List Output, PowerBI, Query Parameters3 Comments
Power BI, Power BI Desktop, SQL Server, SQL Server 2016, T-SQL

Power BI Desktop Query Parameters, Part2, Dynamic Data Masking and Query Parameters

As I promised in my earlier post, in this article I show you how to leverage your Power BI Desktop model using Query Parameters on top of SQL Server 2016 Dynamic Data Masking (DDM). I also explain very briefly how to enable DDM on DimCustomer table from AdventureWorksDW2016CTP3 database. We will then create a Power … Continue reading Power BI Desktop Query Parameters, Part2, Dynamic Data Masking and Query Parameters

Share this:

  • Click to share on LinkedIn (Opens in new window)
  • Click to share on Twitter (Opens in new window)
  • Click to share on Reddit (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on Telegram (Opens in new window)
  • Click to share on WhatsApp (Opens in new window)
  • Click to share on Pocket (Opens in new window)
  • More
  • Click to share on Skype (Opens in new window)
  • Click to email a link to a friend (Opens in new window)

Like this:

Like Loading...
May 6, 2016February 16, 2022DDM, Dynamic Data Masking, Execute As, PBIT, Power BI, Power BI and DDM, Power BI and Dynamic Data Masking, Power BI Desktop, Power BI Desktop Templates, Power BI Query Editor, Power BI Query Parameters, Query Parameters, Revert, SQL 2016, SQL Context Switching, SQL Server 2016, T-SQL, T-SQL in Power BI Desktop Parameters, T-SQL In Query Parameters4 Comments
Power BI, Power BI Desktop, SQL Server

Power BI Desktop Query Parameters, Part 1, Introduction

One of the coolest features added to the April 2016 release of Power BI Desktop is “Query Parameters”. With Query Parameters we can now create parameters in Power BI Desktop and use them in various cases. For instance, we can now define a query referencing a parameter to retrieve different datasets. Or we can reference … Continue reading Power BI Desktop Query Parameters, Part 1, Introduction

Share this:

  • Click to share on LinkedIn (Opens in new window)
  • Click to share on Twitter (Opens in new window)
  • Click to share on Reddit (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on Telegram (Opens in new window)
  • Click to share on WhatsApp (Opens in new window)
  • Click to share on Pocket (Opens in new window)
  • More
  • Click to share on Skype (Opens in new window)
  • Click to email a link to a friend (Opens in new window)

Like this:

Like Loading...
May 5, 2016February 16, 2022Data Source Parameters, Dataviz, DDM, Dynamic Columns in Power BI, Dynamic Data Masking, Dynamic Data Sources, Filter Row, Parameterizing Data Source, Power BI, Power BI Desktop, Power BI Desktop Templates, Power BI Dynamic Columns, Power BI Dynamic Data Sources, Power BI Parameters, Power BI Query Editor, Query Parameters, SQL Server 2016, T-SQL, T-SQL in Power BI Desktop Parameters, T-SQL In Query Parameters34 Comments

Posts navigation

Older posts
Soheil Bakhshi Microsoft Data Platform MVP

Order My Book Here

Expert Data Modeling with Power BI
Expert Data Modeling with Power BI

Free Ebook

Power BI For Intermediates; A Step-by-Step Training Guide, Soheil Bakhshi
A collaboration with Theta NZ Team
MCSE Badge
MCSA Bagde

Get in touch

  • LinkedIn
  • Twitter
  • RSS Feed
  • Link

Subscribe

Categories

Recent Posts

  • Good Practice: Use Security Groups in Role Mapping Instead of User Accounts in Power BI Row Level Security (RLS)
  • Datatype Conversion in Power Query Affects Data Modeling in Power BI
  • Endorsement in Power BI, Part 2, How to Endorse?
  • Endorsement in Power BI, Part 1, The Basics
  • Dynamically Passing Parameters to a SQL Stored Procedure in Excel 365 Using Power Query

Follow me on Twitter

Tweets by biinsightnz

AAS Azure Azure Analysis Services Data Data Model Data Modeling Data Modelling Data Preparation Dataset Data Transformation Data Visualisation Data Visualization Dataviz DAX ETL Excel M PBIX Power BI PowerBI Power BI Admin Power BI Cloud Power BI Designer Power BI Desktop Power BI Personal Gateway Power BI Service Power Pivot PowerPivot PowerQuery Power Query Query Parameters Report Role-playing dimension SQL SQL Server SQL Server 2016 SQL Server Data Tools SQL Server Management Studio SSAS SSAS Tabular SSDT SSMS T-SQL Tabular Transformation

Privacy Policy

%d bloggers like this: