Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,Need help on this issue.
1.I am trying to get data from hive,for this i am using ODBC connector as source connector in POWER BI.
2.If it is directly fetching data from table then there is no issue on this in POWER BI.
3.But when i am using one query i.e having temporary tables.please refer below query.
HIVE:
create table if not exists TEMP1 as select * from Table1
select * from TEMP1
NOTE: Query is working fine in HIVE,in zeppline i have verified its working fine.but while using above query facing issue while fetching data from HIVE(ODBC) in power BI.
Please help me on this.
@adityapv , I doubt you can run this from power bi.
Power bi will run query for resultset I doubt this will work in that case
Try if with works
With TEMP1 as ( select * from Table1)
select * from TEMP1
User | Count |
---|---|
103 | |
87 | |
77 | |
70 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |