Power BI SQL API Issue: Works in DAX Studio but receiving error in power BI.

[krutoileshii]

Failed SQL On the server seems to run fine but fails in PowerBI Desktop with error Message:

1. OLE DB or ODBC error: [DataSource.Error] PostgreSQL: Received backend message BindComplete while expecting ParseCompleteMessage. Please file a bug..

2. Actual Cubes Attached as well.

dim_pbi_reports.yml dim_pbi_workspaces.yml fct_pbi_activities.yml

dim_date.yml dim_dbt_resources.yml dim_pbi_datasets.yml dim_pbi_reports.yml dim_pbi_users.yml dim_pbi_workspaces.yml fct_pbi_activities.yml fct_pbi_workspace_membership.yml

{ "sql": "select "rows"."basetable0.c40" as "c40", count(1) as "a0" from ( select "$Outer"."basetable0.c40" from ( select ""."activity_type" as "basetable0.c40", ""."__cubeJoinField" as "basetable0.c58" from "public"."activities" "" where ""."activity_type" in ('CancelDatasetRefresh', 'AnalyzedByExternalApplication', 'Import', 'ConnectFromExternalApplication', 'DeleteComment', 'TookOverDataflow', 'UpdateApp', 'CreateReport', 'ViewDataflow', 'CreateEmailSubscription', 'DeleteEmailSubscription', 'DownloadReport', 'AddTile', 'DeleteDashboard', 'EditDataset', 'DeleteDataset', 'RunEmailSubscription', 'DeleteReport', 'ExportReport', 'ExportTile', 'ViewDashboard', 'GetWorkspaceEncryption', 'UpdateFolderAccess', 'CreateDataflow', 'EditReport', 'TakeOverDataset', 'CreateFolder', 'CreateDataset', 'GenerateDataflowSasToken', 'UpdateFolder', 'GetGroupUsersAsAdmin', 'ArtifactAccessRequest', 'GetUnusedArtifacts', 'GetPowerBIDataModel', 'CreateDashboard', 'GetDataflowUsersAsAdmin', 'RefreshDataset', 'PrintReport', 'PostComment', 'SetScheduledRefresh', 'ReadDataflow', 'GetDataflowDatasourcesAsAdmin', 'RequestDataflowRefresh', 'UpdateEmailSubscription', 'GetPowerBIDataModelDiagramLayouts', 'UpdateDatasetParameters', 'ShareReport', 'ShareDataset', 'CancelDataflowRefresh', 'ViewReport', 'UpdateDataflow', 'UnpublishApp', 'ExportArtifact', 'AnalyzeInExcel') ) "$Outer" inner join ( select "rows"."__cubeJoinField" as "semijoin1.c58" from ( select ""."__cubeJoinField" from "public"."workspaces" "" where "_"."workspace_type" = 'Workspace' ) "rows" group by "__cubeJoinField" ) "$Inner" on ("$Outer"."basetable0.c58" = "$Inner"."semijoin1.c58" or "$Outer"."basetable0.c58" is null and "$Inner"."semijoin1.c58" is null) ) "rows" group by "basetable0.c40" limit 1000001" }

Logical Plan N/A

Tool Power BI using SQL API

Version: Latest

Additional context The error only occurs inside PowerBI, Works just fine in dax, web interface, etc.

Here is a working DAX Query in DAX Studio /* START QUERY BUILDER / EVALUATE SUMMARIZECOLUMNS( workspaces[workspace_name], workspace_reports[report_name], activities[report_id], workspace_reports[count], activities[count], KEEPFILTERS( TREATAS( {"Workspace"}, workspaces[workspace_type] )), KEEPFILTERS( TREATAS( {"ViewReport"}, activities[activity_type] )) ) ORDER BY workspaces[workspace_name] ASC, workspace_reports[report_name] ASC, activities[report_id] ASC, workspace_reports[count] ASC, activities[count] ASC / END QUERY BUILDER */