Paramter handle in Snowflake View to take it as a source in Power BI Report Builder

[Anonymous]

Hi Team,

I am using the Power BI report builder and Snowflake as a source for it. I need to convert the complex SP (SQL Server) to Snowflake View/SP.

In SP(SQL Server), I am having the multiple parameters (Query Level and Column Level) and all these should handle in Snowflake view/SP and I shouldn’t do any major work from Power BI Report Builder. I can simply call the view/SP from snowflake  to Power BI Report Builder for Paginated reporting.

Example: Suppose if I have the column logic as -
Create View ViewName as 

Select 

Case when @Paramter = P then ColumnA else ColumnB end as [LogicalColumn]. 
from TableName .

How can I define the above parameter in view creation and how to configure it in Power BI Report Builder.
How to handle this Paramerter concept  in Snowflake view

Please do the needful guys . Thank you in Advance.

[Anonymous · Accepted solution]

Hi @Anonymous ,

First of all, it should be clear that the paginated reports only supports these data sources in the table below. Please read this official documentation for more details.

Supported data sources for Power BI paginated reports

And you may need to consider connecting to Snowflake on desktop first, processing the data, and then uploading it to the service to generate a dataset. Then connect to the previously generated dataset in report builder. For more details, please see the link below.

Connect to Snowflake in Power BI Desktop

Create a paginated report based on a Power BI shared dataset

Finally, about how to create and set parameters in the report builder. You can refer to the following documentation.

Create parameters for paginated reports in the Power BI service

Power BI Paginated Reports Part 11 - More Parameters Tips and Tricks

Best Regards