Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a query that loads all the data from an access table (Query1).
I then have another query (Query2) which aggregates data from Query1.
I then have another query (Query3) that aggregates data from Query2.
My problem is that whenever I refresh, all three queries try to connect to the Access database at the same time and I get an error.
Is it possible to create a query chain like this that only loads data from the Access database into memory once (Query1) and Queries 2 & 3 only run from the in memory Q1?
Based on my research, you might need to retain only one query in Query Editor, and perform aggregation operation in DAX.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |