Forum Discussion
jja
Helper III
Helper IIIduplicating table fails
Hi I have a stored procedure inside SQL that generates a #temptable i can load this procedure intio powerbi and i get my table for other task i need to unpivot this table and i tried to referen...
I found how to solve the issue. IT was wrong choice in sql procedure to use global temp tables. I switched to local temp tables and then i can run the procedure twice in data enquery
Please share the code so we can see what happens in your model.
You may read this article see if helps: Chris Webb's BI Blog: Why Is Power BI Running My SQL Query Twice? Chris Webb's BI Blog (crossjoin.co.uk)
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.