"View SQL" in Visual Queries doesn't work well

[DennesTorres]

Hi,

I created a visual query with a merge and a group by. The "View SQL" button only shows the initial query, doesn't show the query with the final result.

[DennesTorres]

As a consequence, this also prevents the download of the result to Excel:

After some tests, I discovered part of the problem is because I created multiple aggregations on the Group by option. After removing them, leaving only one, the "Download Excel file" worked, the query was translated to SQL. However, the "View SQL" on the visual query still doesn't work, showing only the initial query.

[Anonymous]

Hi  @DennesTorres ,

Can you provide detailed version information so we can reproduce the issue? We'll get back to the product team as soon as it's acknowledged as an issue!
Thanks in advance!

Best regards.
Community Support Team_Caitlyn

[DennesTorres]

Hi,

Sorry, I'm not sure what you mean about "version information".

These problems are in the portal, related to Microsoft Fabric. Power BI Desktop is not involved.

Kind Regards,

Dennes

[Anonymous]

Hi @DennesTorres ,

I haven't received any feedback from other users with similar experiences to yours, and yes, I'm referring to the version of Power BI Service, which you can check out in the About section!

Best regards.
Community Support Team_Caitlyn

[DennesTorres]

Hi,

I can record a short video with the issue if you would like.

Kind Regards,

Dennes

[Anonymous]

Hi  @DennesTorres ,

The problem should no longer occur and you can retry later.
If there are further questions, please feel free to let me know.

Best regards.
Community Support Team_Caitlyn

[DennesTorres]

Hi,

The problem still happens.

This should be a query with a join and group by, but the "View SQL" doesn't produce the result:

I tested this just now and captured the screen