Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am using Power BI to invoke a stored procedure in Snowflake and display the data. The steps followed are below:
-Created Parameters
-Created Base query calling the stored procedure by passing the parameters from the previous step.
-Created another query to reference the base query and display the data
The entire thing is working as expected in Power BI Desktop. When I publish the report in Power BI Service I am able to do the following:
-Pass Parameters
-Invoke the Base query calling the stored procedure
But the third step which used to display the data is not working. Power BI is not sending the query to the database and refreshing the report.
The below is the Base query:
let
Source = Odbc.Query("dsn=SFDB", "call SP (P1,P2,P3)")
in
Output
I am using the below query in reference the base query and display the data:
Table1
let
Source = SPQuery,
Output = Odbc.Query("dsn=SFDB", "SELECT C1,C2,C3")
in
Output
Can you tell me if its possible to call reference queries in Power BI Service. Is there any settings to be made in Power BI Service or Desktop to make this run correctly?
I am using a Personal Gateway and ODBC connection.
@Anonymous
Make sure Include In Report Refresh and Enable Load are enabled.