Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.