If the data source is a SQL Server stored procedure in PowerBI, is it possible to do query folding in PowerQuery?
I am currently working with PowerQuery and would like to understand if query folding is possible when using a SQL Server stored procedure as a data source.
Query regarding MDX CALL statements for stored procedures in Power BI
I wanted to inquire if it is possible to call a stored procedure using the MDX CALL statement in Power BI. Specifically, I would like to know if this approach would enable query folding, thereby improving performance when retrieving data from the database.