PowerQueryNet
PowerQueryNet copied to clipboard
gsimardnet
Run M Language (Power Query Formula Language) from anywhere.
Hello, Thank you for this project! It proves that an idea of mine is feasible and inspires to pursue it. Could you please explain how does it work internally? Especially...
This query ``` let List = {1..20}, Result = List.Split(List, 4) in Result ``` fails with `The name 'List.Split' wasn't recognized. Make sure it's spelled correctly.` List.Split is a valid...
A query with fairly complex logic that cleans some atrociously formatted Excel files and writes the result to SQL Server works for up to a few dozen files but times...
Trailing comments in a PQ document can cause an error (I tested by adding comments to one of a few pq files in a folder). If you have ``` let...
When executing multiple pq files within the same directory and a syntax error occurs PQnet will helpfully pass along the error message. If the pq file is too long the...
How would one go about using this with a custom pqx or mez extension?
I just tried ```pqnet helloworld.pq helloquery``` but got this error: ```CreateMashupConnectionInfo has failed.``` How can I find out what's wrong?
I found this seems to happen whenever a hyphen is in the file name. ```Powershell 'let A =1 in A' | Out-File My-File.pq pqnet.exe My-File.pq #Token Equal expected. Start position:...
I have a question about providing credentials to the Azure Blob Storage. I would like to read csv from storage. This is a simple powerquery: ``` let Source = AzureStorage.Blobs("my_account"),...
I have a problem with running basic HelloWorld example: `var q = new Query { Formula = "let hw = \"Hello World\" in hw" };` `var pq = new PowerQueryCommand();`...
Metadata
Owner
Metadata
Run M Language (Power Query Formula Language) from anywhere.