CODEWITHSUNDEEP
azurepowerbi
Stanislav Jirák
Stanislav Jirák

Reputation: 485

Connect to a stored procedure with parameters on a server in PowerBI

I wrote a stored procedure which takes in a given string from an user (within the report) as a parameter and searches through tables and attributes (Information Schema) stored on a SQL server in Azure. I'd like to display the results in PowerBI desktop w/o the need of downloading all the data/bd. I don't have an access to PowerBI embed. Is that possible?

Upvotes: 0

Views: 147

Answers (1)

David Browne - Microsoft
David Browne - Microsoft

Reputation: 89051

Paginated Reports (aka SSRS reports, aka RDL Reports) can do this.

But Power BI Reports would need to load all the data into the Power BI DataSet, or refer to the underlying tables/views in DirectQuery for interactive filtering.

Upvotes: 1

Related Questions