Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
Hi
May I know if it's possible to get temp table data? Cause I'm using very simple statement, and it not works.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |