How to utilise stored procedure with temp tables in Power BI?

Question

I like to store procedure containing temp tables in the dataset

I have tried with

Query="EXECUTE [kpi].[KPI_NV]"])

 and 

Sql.Database("CZPHADDWH01\DEV", "DWH_Staging", [Query="EXECUTE [kpi].[KPI_NV]"])

which raises an error 

Details: "Microsoft SQL: Incorrect syntax near the keyword 'Database'. Unclosed quotation mark after the character string '])'."

Answer 1

We can use Withresultset syntax, on behalf of OpenQuery

If u want to know more about the course then check the Power Bi Certification