Run one query based on the results of another

[NotSteve]

I have two tables and table A has 7000 distinct values, table B has 4 million.  Every value in table A has multiple entries in table B.  Both are populated from SSMS queries.  I want to be able to choose a value in table A then have query B run based on the user chosen filter for table A.  I don't want to load 4M records in table B every time.  Is this possible?

[Anonymous · Accepted solution]

Hi @NotSteve ,

You try connecting to data sources using DirectQuery or Live Connection, which have the following advantages:

With DirectQuery/Live Connection, upon load, no data is imported into the Power BI store. Instead, when you build a visual, Power BI Desktop sends queries to the underlying data source to retrieve the necessary data. The time it takes to refresh the visual depends on the performance of the underlying data source.

DirectQuery in Power BI - Power BI | Microsoft Learn

Power BI Connection Types: DirectQuery, Live, or Import? Tough Decision! - RADACAD

Best Regards,

Stephen Tao

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