Open TD Console.
Navigate to the Data Workbench > Queries.
Select New Query.
Select the database for which you would like to export data.
Type your query into the query editor.
Select Output Results.
A dialog Choose Saved Connection is displayed.
Select an existing power_bi connection.
If you do not have a Saved Connection already setupset up, see Creating a New Connection During Data Export.
Specify the export details. Dataset and table are required.
Optionally, type a value for Workspace ID.
The Workspace ID is a PowerBI workspace or group id that allows users to share their work.
Optionally, choose whether to replace existing data or not.
If chosen, TD deletes all the data before replacing it with fresh data during the export.
Review the limits for your plan and type a value for your Service plan rows limit.
Max rows added per hour per dataset for service plans. Free service plan allows 10,000 rows. Paid service plan allows 1,000,000 rows.