cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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
Highlighted
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...

 


I have book! Learn Power BI from Packt


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

Proud to be a Datanaut!

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 240 members 2,629 guests
Please welcome our newest community members: