Forum Discussion
Different results when using the Direct Query vs. Import options
jhenscheid wrote:
I am relatively new to Power BI. I am not a programmer, but in working with one of my co-workers, he wrote a sql for me to bring back test results to display a trip (order) from our system. I pasted the sql using the Direct Query mode option and I get the desired results. However, when I try to bring back similar results using the Import mode option and joining the tables, I do not get the same results. My guess is that I am joining the tables incorrectly or that there are options in modeling the data that I am either doing incorrectly or not aware of.
The relationship in the snapshot looks good. What did you do to get the same results? Create a calculated table or what? Is it possible for your to upload the importmode pbix file?
Just to be clear, when I used the sql as a direct query, I got the desired results but they were not the same as when I used the Import mode. Unfortunately, I am not able to currently upload the import mode file. If needed for a solution, I can try to do this. I think the main difference or is in the sql I can bring back the max row on the table for the primary key. How would I do that in Power BI? Is that a group function or is there a way to set up a calculation to bring back the max row?
Thanks
