Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I'm stuck. I combined three large excel-sourced Power Query queries into one combined query using Load To "connection only" and then in final step after combining went to Load To: and unchecked Load to Data Model. My power pivot model worked fine until I did a Refresh of the query (of combined three queries). The refresh shows the correct count, say 1.2m records in Power Query but my data model in Power Pivot shows a count of only (say) 1m, 200K less records. I have refreshed both from power Pivot (data view) and from within Power Query a couple times. Power Query shows the 1.2m records but Power Pivot / Data View shows only the 1.0m. Can anyone see what I need to do to get the full 1.2m count into Power Pivot? Thanks for all your support. Jeff
@Anonymous
Hi Jeff,
So you're doing this in Excel?
If you've unchecked the Add this data to the Data Model box then the query results won't get loaded into Power Pivot. So how have you gotten the data into PP? I'm a bit unclear as to what data you are looking at in PP.
Regards
Phil
Proud to be a Super User!
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
71 | |
70 | |
38 | |
26 | |
26 |
User | Count |
---|---|
99 | |
87 | |
45 | |
43 | |
35 |