Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I'm trying to change the data source of a query using a parameter, but I can't figure out the correct syntax. Here's my query:
let Source = OleDb.DataSource("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Temp\;extended properties=dBASE IV", [Query="select * from [JunctOut.dbf]"]) in Source
I want to be able to change the data source to a different path (currently C:\Temp\ in the example above). I've created a parameter called FolderPath, but can't figure out how to get it into my query.
Any suggestions?
Solved! Go to Solution.
@rickscr,
Change your code to the following:
let Source = OleDb.DataSource("Provider=Microsoft.ACE.OLEDB.12.0;Data Source="&FolderPath&";extended properties=dBASE IV", [Query="select * from [JunctOut.dbf]"]) in Source
Regards,
Lydia
@rickscr,
Change your code to the following:
let Source = OleDb.DataSource("Provider=Microsoft.ACE.OLEDB.12.0;Data Source="&FolderPath&";extended properties=dBASE IV", [Query="select * from [JunctOut.dbf]"]) in Source
Regards,
Lydia
Perfect! Thanks!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |