Export Query Designer result - Power BI Report Builder

[jding]

I am using Dataverse to diectly connect to Dynamics CRM. I'd like to export/save the query result but nothing I can do in the Query Deigner. I could build a report and export the data to Excel from there but it is not supposed to do in this way. Dose anyone have a better solution? Thanks.

[Icey · Accepted solution]

Hi @jding ,

What's your purpose of using Power BI Report Builder?

If you are interested in just querying and exporting data, the same thing can be achieved using SQL Management studio. For more details, please check:

Use SQL to query data (Microsoft Dataverse) - Power Apps | Microsoft Docs

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[garythomannCoGC]

Query Designer is a bug and should be removed/commented out 

Vote to have QD removed from the m$ code base.

[Icey · Accepted solution]

Hi @jding ,

What's your purpose of using Power BI Report Builder?

If you are interested in just querying and exporting data, the same thing can be achieved using SQL Management studio. For more details, please check:

Use SQL to query data (Microsoft Dataverse) - Power Apps | Microsoft Docs

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jding · Accepted solution]

HI Icey,

Thanks for the reply. It is very helpful.

Yes, I can use SQL Studio to query the data but it will be convenient if the query result can be directly saved from Query Designer. Lots of cases, the query result needs to be checked and verrified by business users before running the final report. If the query result can be saved inside Query Designer, a single dataset can be serving for 2 purposes instead of copy and pasted SQL back and forth in different environments.