Temporary Tables in power bi

[Anonymous]

Hello,

I have an problem with power bi.How we can use temporary tables in power bi?

That means 

I wrote a query like this in power bi while connect the data.

select * into #abc from main table

select * into #abc1 from 

abc 

  inner join

main table2 

on abc.id=maintable2.id

while Iam writing this in power bi first table "abc" is loaded it did not shows any columns

just it shows number of rows effected.

it shows an error 'abc table does not exist' when we use the "abc" table.Is it right to achieve this?

or is there any way?Please suggest.

Thanks,

Chunduri

[v-qiuyu-msft · Accepted solution]

Hi @Anonymous,

There are some error in your second query, when you reference the #abc table, you need to use #abc rather than abc. As both #abc and maintable2 have id column, you need to specify id column. You can modify the query like below: 

select * into #abc from Main1

select m2.* into #abc1 from #abc 
inner join Main2 m2
on #abc.id=m2.id
select *from #abc1

Before you run the query in Power BI, make sure the query works in SSMS firstly. 

Best Regards,
Qiuyun Yu 

[juchen]

Hi

May I know if it's possible to get temp table data? Cause I'm using very simple statement, and it not works.