Good day,
I'm working on integrating the Power BI in our Power Apps. After some research we've managed to connect our SQL Stored Procedure in Power BI by changing the Power Query and adding a parameter LoggedUser in Power BI. The Stored Procedure only accepts 1 parameter named @LoggedInUser_DomainId in SQL.
In Power Apps, I've used the Power BI Tile then add the URL from the Power BI Report I've created after publishing it. I've added a combobox with different names that was supposed to be passed in Power BI as a value for the LoggedUser then click run and the stored procedure inside the Power BI will run and refresh the report shown in Power Apps screen.
I found out you can filter the current data set shown in Power BI tile by concatenating the URL with
&filter=PowerResult/LoginId eq '"& SelectedUser &"'"
SelectedUser is the variable set whenever I'm hitting the Run button that gets the current selected name in ComboBox.
But this approach only filters the current dataset shown in Power BI and it's not running the Stored Procedure connected to it again to refresh the data.
The properties of Power BI tile inside Power Apps are like this:
AllowNewAPI = true
LoadPowerBIContent = true
PowerBIInteractions = true
Reset = false
I'm not sure how to approach this. Any suggestions?
