Forum Discussion

quizhyo's avatar
quizhyo
Icon for Advocate I rankAdvocate I
3 years ago

Create the report from Query of Datamart

Hi, 

My datamart has a lot of tables, So I try to reduce it by creating a query (Visual Query). 

 

After that, I want to load the data source from this query. Is it possible? 

 

Best regards,

Hung

Tutorial Requests

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi  quizhyo ,

     

    According to your description, when you connect to a data source, you have a lot of Tables, do you want to create a Visual Query to query some of the Tables and then load only the data in those partial Tables?

    First of all, Datamart is the cloud equivalent of Power BI Desktop; there may not be a way to implement the ability to refresh only some of the Tables at this time. For your needs, you may consider selecting partial Tables when creating a Datamart and creating multiple Datamarts to meet your needs.

    Or you can try to use DataFlow to create the Query you need and then use Power BI Deskotp to get the data in Dataflow to develop the report.

    Refer to:

    Creating a dataflow - Power BI | Microsoft Learn

     

    Best Regards,

    Liu Yang

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