Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi I have two simple queries on is
Create a temp table vt_nm;
and the other one is to select data from the temp table vt_nm
I saw the solution for the above issue in Teradata community but that did not work.
I cannot run DDL and DML statement together?
Then how am I suppose to run the query?
Any help or suggestion is really appreciated.
Solved! Go to Solution.
@cpai1,
Do you write the SQL query in optional textbox during the process that you import data from Teradata to Power BI Desktop?
If so, "Create a temp table vt_nm" is a DDL statement, it is not possible to run DDL statement in Power BI, please write "SELECT * FROM fixedTable" in desktop query box to import Teradata data.
Regards,
Lydia
@cpai1,
Do you write the SQL query in optional textbox during the process that you import data from Teradata to Power BI Desktop?
If so, "Create a temp table vt_nm" is a DDL statement, it is not possible to run DDL statement in Power BI, please write "SELECT * FROM fixedTable" in desktop query box to import Teradata data.
Regards,
Lydia
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.