Forum Discussion

jja's avatar
jja
Helper III
5 years ago
Solved

duplicating 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...
Need Help
  • jja's avatar
    jja
    5 years ago

    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

Jimmy801's avatar
Jimmy801
Community Champion
5 years ago

Hello jja 

 

could you share some M-code and tell us where you are referencing your SQL twice?

 

BR

 

Jimmy

  • jja's avatar
    jja
    Helper III
    5 years ago

    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