Hi all,
I have used power query to established a connection to a an access database file with almost 3 million rows. However, I am trying to edit the Command Text properties under the definition tab. Currently the connection string is Provider=Microsoft.Mashup.OleDb.1;Data Source=$Workbook$;Location=FFRQuery, connection type is Table Collection and the Command Text is "FFRQuery"
Desired Changes
Command Type SQL
Command Text "SELECT * FROM FFRQuery WHERE [System Source]='BAP' OR [System Source]='BPO' OR [System Source] ='BGL'"
Thanks.
I have used power query to established a connection to a an access database file with almost 3 million rows. However, I am trying to edit the Command Text properties under the definition tab. Currently the connection string is Provider=Microsoft.Mashup.OleDb.1;Data Source=$Workbook$;Location=FFRQuery, connection type is Table Collection and the Command Text is "FFRQuery"
Desired Changes
Command Type SQL
Command Text "SELECT * FROM FFRQuery WHERE [System Source]='BAP' OR [System Source]='BPO' OR [System Source] ='BGL'"
Thanks.