Monday, 18 March 2013

Export MySQL Table to a CSV File

SELECT * FROM DatabaseName.DesireTable
INTO OUTFILE 'd:\\output.csv' 
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';
 

Connect PowerBI to SQL Server - TrustServerCertificate

Under the server that Power BI installed,  Go to System Properties -> Advanced -> Environment Variables  Add this Variable Name PBI_S...