Take data from Stored Procedures (Multiple if too )

RE: Take data from Stored Procedures (Multiple if too )

Right now, this is a MAJOR hole in PowerBI. When we deal with extremely large datasets, it is cumbersome to pull those datasets into the nightly cache offered by the Premium service and then cumbersome to deal with filtering the data down that is transmitted to the user, especially over remote internet connections being used by people working at home. Using parameterized stored procedures is a age old norm used by SSRS and other competing products that was completely overlooked in PowerBI. This should be a direct query feature and needs to be present in order for large enterprises to be willing to migrate from SSRS to PowerBi..