Forum Discussion

Sophie__'s avatar
Sophie__
Helper I
8 months ago
Solved

Model composite with seperate table

Hello, I have a composite model with a FACT table in direct query and dimension tables in dual connection.     The direct query model works correctly when using dimension data with a calc...
Need Help
  • v-achippa's avatar
    v-achippa
    8 months ago

    Hi Sophie__ ,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Thank you amitchandakand MFelix for the prompt response.  

    As we haven’t heard back from you, we wanted to kindly follow up to check if the response provided by the user's for the issue worked? Is your issue resolved?

     

    If not please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
    Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
    Please show the expected outcome based on the sample data you provided.

    https://community.fabric.microsoft.com/t5/Power-BI-Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

     

    Thanks and regards,

    Anjan Kumar Chippa

MFelix's avatar
MFelix
Super User
8 months ago

Hi Sophie__ ,

 

Is that specific field comming from what table?

Sophie__'s avatar
Sophie__
Helper I
8 months ago

Hi MFelix , 

This is a specific field that comes from a dimension table.

A second query is launched directly:

SELECT `je_header_description`,

`je_line_description`
FROM `fco-data-gsp-products-dev`.`profit_and_lost_exp_dev`.`dmt_dim_gl_v`
GROUP BY `je_header_description`,

`je_line_description`
LIMIT 1000001 OFFSET 0

This query retrieves over 1 million rows.

I don't understand why i have this second request.

 

Regards,

Sophie

  • MFelix's avatar
    MFelix
    Super User
    8 months ago

    Apologies for the additional questions.

     

    But what type of relationship is this? I see in your image that you have a many-to-many relationship but not sure what is the table.

     

    What is this dimension role in the information you are getting?

    Do you only have one period selected or do you show all of the periods at the same matrix?

    • v-achippa's avatar
      v-achippa
      Community Support
      8 months ago

      Hi Sophie__ ,

       

      Thank you for reaching out to Microsoft Fabric Community.

       

      Thank you amitchandakand MFelix for the prompt response.  

      As we haven’t heard back from you, we wanted to kindly follow up to check if the response provided by the user's for the issue worked? Is your issue resolved?

       

      If not please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
      Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
      Please show the expected outcome based on the sample data you provided.

      https://community.fabric.microsoft.com/t5/Power-BI-Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

       

      Thanks and regards,

      Anjan Kumar Chippa

      • v-achippa's avatar
        v-achippa
        Community Support
        8 months ago

        Hi @Sophie__ ,

         

        We wanted to kindly follow up to check if the response provided by the user's for the issue worked? Is your issue resolved?

        If not please provide sample data in a usable format.
        Please show the expected outcome based on the sample data you provided.

         

        Thanks and regards,

        Anjan Kumar Chippa