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';
 

Analysis Service in Power BI Report Server

 We couldn’t connect to the Analysis Services server. Make sure you’ve entered the connection string correctly... link