Forum Discussion
Power BI and Teradata Volatile or Temporary Tables
Does Power BI support temporary tables as a data source using SQL? Simple example below using temporary table format from Teradata.
CREATE MULTISET VOLATILE TABLE VT1 AS (
SELECT * FROM
DATABASE1
WHERE CONDITION = 'ABC'
) WITH DATA NO PRIMARY INDEX ON COMMIT PRESERVE ROWS;
SELECT * FROM VT1;
Anonymous
Power BI does not natively support temporary tables (like the VOLATILE TABLE concept in Teradata) as a data source. This limitation arises because Power BI connects to databases and expects persistent tables rather than transient ones that exist only during a session.
1 Reply
- Kedar_Pande
Super User
Anonymous
Power BI does not natively support temporary tables (like the VOLATILE TABLE concept in Teradata) as a data source. This limitation arises because Power BI connects to databases and expects persistent tables rather than transient ones that exist only during a session.