cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
blackwelc Frequent Visitor
Frequent Visitor

Avoiding SSRS parameters

I often get requests to utilize existing SSRS reports to develop into PowerBi Dashboards. Most of these SSRS reports use stored procedures with multiple parameters. However, for the dashboards we would not want any parameters and would want a full dataset or in the least only utilize a date range parameter. So my question is in PowerBi, is it possible to leave a parameter blank or a wildcard such as * to pass all the data as opposed to narrowing the dataset down?  This would save a large amount of time as opposed to recreating the stored procedure minus the parameters for PowerBi use

1 REPLY 1
Super User
Super User

Re: Avoiding SSRS parameters

This is going to depend a bit on the structure of your SQL stored procedures but you should be able to call those stored procedures with parameters like *, % and _. See this article on SQL wild card characters.

 

https://support.microsoft.com/en-us/help/98434/how-to-use-wildcard-characters-in-the-sql-select-stat...

 


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 220 members 2,435 guests
Please welcome our newest community members: