Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

0

How to get Snowflake Parameterised view in Power BI Report Builder

Whenever calling Snowflake Parameterised view in Power BI Report Builder like below I am getting error. Please let me know how to call them for Paginated reports

 

I have created below view 

Create or Replace view View as
Select Case when Id = $Id then EmpId end as Parameter
From EmpTable;

 

Calling view as below in Power BI Report Builder in Dataset Query 

Set Id = (?);
Select Parameter from View ;

Getting below error 

YambaniMuni_0-1651858281579.png

Please do the needful
Thanks in Advance 

Status: Delivered
Comments
Anonymous
Not applicable

Hi , @Anonymous 

Sorry for that Power Bi Report Builder just supports the following list of data sources: 

Ailsamsft_1-1652062294659.png

For specific information, you can refer to the following documents.

https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-data-sources 

 

Best Regards,
Community Support Team _ Ailsa Tao