Forum Discussion

Federica_18's avatar
Federica_18
Regular Visitor
5 years ago
Solved

Merge Queries

Hi,

I have two tables of 11,246,448 rows and 24 columns. One containing the real values and the other containing the expected values. In order to create an overlaid line chart consisting in both real and expected data I created a query merge but at the moment of closing and applying the load it does not give me any result. I was wondering if it is possible to explain me why this happens. Could it be a license problem? I have the free trial version of Power BI Desktop Premium

 

Kind regards,

Federica

Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    Hey Federica_18 ,

     

    can you show us the chart and how you put in the fields?

    How do you differentiate between real and expected values? This must be two different values.

     

    You could also have done that with 2 fact tables and the proper dimension tables.

     

    Best regards

    Denis

  • selimovd's avatar
    selimovd
    5 years ago

    Hey Federica_18 ,

     

    you could let it as two separate tables and use a date table that you connect with both:

    Power Bi for Beginners: How to create a Date Table in Power Bi - Softcrylic

     

    Then you just have to put the date of the dimensional date table in the graphic and the values from the 2 fact tables and you got your result.

     

    For the "merge", I don't think you need to do a merge in Power Query. You should try the append as puts one table below the other table. Try that one:

     

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     

3 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    Hey Federica_18 ,

     

    can you show us the chart and how you put in the fields?

    How do you differentiate between real and expected values? This must be two different values.

     

    You could also have done that with 2 fact tables and the proper dimension tables.

     

    Best regards

    Denis

    • Federica_18's avatar
      Federica_18
      Regular Visitor
      5 years ago

      Hi selimovd , 

       

      This is the table containing the real values:

       

       

      I have columns containing latitude, longitude, date and time of day, temperature, humidity etc. For each coordinate I have measurements made for 31 days at all hours of the day.

      The same thing for the table containing the expected values:

       

      Moreover, I thought it could be useful to create a query merge and make a graphs in the following way:

      x-axis: date and time of day;

      y-axis: measured values (e.g. temperature)

      Red line: actual temperature
      Blue line: expected temperature

      The problem is that when I merge queries, the load fails. Is there another way to make this chart without joining the two tables?

       

      Thank you for your time

      Federica

      • selimovd's avatar
        selimovd
        Most Valuable Professional
        5 years ago

        Hey Federica_18 ,

         

        you could let it as two separate tables and use a date table that you connect with both:

        Power Bi for Beginners: How to create a Date Table in Power Bi - Softcrylic

         

        Then you just have to put the date of the dimensional date table in the graphic and the values from the 2 fact tables and you got your result.

         

        For the "merge", I don't think you need to do a merge in Power Query. You should try the append as puts one table below the other table. Try that one:

         

         

        If you need any help please let me know.
        If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
         
        Best regards
        Denis