I have a power bi dataset published in direct query from SQL.
I use that published dataset in Power BI Report Builder to build Paginated Reports.
I want to pass parameters from Power BI Report Builder to the Power BI Dataset (direct query) how can I do that.
So the direct query from power bi pbix returns only the data I have passed though the parameters from report builder into the dataset and not all into my Report Builder.
Please help