Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Query Database without SQL ? - Datamarts



I'm getting data request from different areas of the business, and although we have everything in the database, and a complex suite of reports that answer most of the day to day needs; every time we get an adhoc request that requires querying the database directly we have a few challenges.


There is no in house resource that knows sql in the level that is needed. 

And we also need to combine different tables to replicate the model's behaviour so that we extract the same numbers.


Is there a way to query the model's dataset inside the service using a graphic interface ? That would be ideal, as it would allow us to maintain the model's measures and calculations while extracting ad hoc requests.


Alternatively, would it be possible to query the database directly using PQ graphic interface ?


I tried using analyse in Excel, but the probably due to the size of the database, the file keeps hanging.
I then tried dataflows but I could only export a json file, without any data.

Finally, I tried datamarts, but the PQ UI keep loading forever. 

A few things to note:

We have +5 years of data, most of the request require 2 or less years of data.

We have multiple tables and some considerations embedded into the model's logic - hence the ideal solution would be to query the model's dataset directly.

Is the cruel answer simply that we lack an IT resource that could help us manage ad hoc request as there is no workaround ?


Community Support
Community Support

Hi @GonzaloB ,


It seems to be more difficult to implement. Is all the data connected to the same data source via a direct query join pattern?

Can you provide the relevant screenshot information and describe it so that I can further answer for you.

Best Regards,


Helpful resources

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.