I'm following the instructions to create a Power BI Query from this page: Using the Power Query SDK - Power Query | Microsoft Learn
In order to see the PowerBI SDK in VS Code, I need to open a folder, so I open an empty folder that will contain what get's built.
When I run the "Create an extension project", all the files get created as documented. In the output, I see the error below. I've tried this a couple of times and always get the same error. Is this to be expected?
- Next I set the credentials and that seems to work and my credentials look like the documented credentials.
- Next I run the evaluate query and I get the error shown below with an apology.
- Finally when I copy and use the .mez file in Power BI Desktop, it seems to work. Why am I getting an error testing in VS Code? Should I be concerned about these errors?
[12:36:43 PM] [Info] PQTest.exe found at c:\Users\bpeltz\.vscode\extensions\powerquery.vscode-powerquery-sdk-0.2.3-win32-x64\.nuget\Microsoft.PowerQuery.SdkTools.2.114.4\tools\PQTest.exe
[12:36:45 PM] [Info] [Task found] c:\Users\bpeltz\.vscode\extensions\powerquery.vscode-powerquery-sdk-0.2.3-win32-x64\.nuget\Microsoft.PowerQuery.SdkTools.2.114.4\tools\PQTest.exe info
--extension "c:\Users\bpeltz\projects\DataConnectorTests\test\MyConnector\bin\AnyCPU\Debug\MyConnector.mez"
--prettyPrint
[12:36:46 PM] [Error] [Task exited abnormally] pqtest info pid(48808) exit(4294967291) stderr: Error: exception while running expression.: We're sorry, an error occurred during evaluation.
[12:36:47 PM] [Info] Detected a newer mez file, about to infer its latest info. 1698781005766, 1698781005766
[12:36:47 PM] [Info] [Task found] c:\Users\bpeltz\.vscode\extensions\powerquery.vscode-powerquery-sdk-0.2.3-win32-x64\.nuget\Microsoft.PowerQuery.SdkTools.2.114.4\tools\PQTest.exe info
--extension "c:\Users\bpeltz\projects\DataConnectorTests\test\MyConnector\bin\AnyCPU\Debug\MyConnector.mez"
--prettyPrint
[12:36:48 PM] [Error] [Task exited abnormally] pqtest info pid(25636) exit(4294967291) stderr: Error: exception while running expression.: We're sorry, an error occurred during evaluation.
[12:47:12 PM] [Info] RunTestBattery result [
{
"ActivityId": "1dd2a446-3c7f-4455-b4f2-8f6fce14ae6c",
"DataSourceAnalysis": [
{
"Kind": "DataSource",
"FunctionName": "MyConnector.Contents",
"DataSource": {
"Kind": "MyConnector",
"NormalizedPath": "MyConnector",
"Path": "MyConnector"
}
}
],
"Details": "We're sorry, an error occurred during evaluation.",
"EndTime": "2023-10-31T19:47:12.5568087+00:00",
"Method": "PQTest.RunTest",
"Name": "MyConnector.query.pq",
"StartTime": "2023-10-31T19:47:12.3114331+00:00",
"RowCount": 0,
"Status": "Failed",
"Type": "PQTest.Expression",
"Error": {
"Message": "We're sorry, an error occurred during evaluation.",
"InnerException": {
"Message": "Cannot create process."
}
}
}
]
