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.
hi,
i have pbi file that pulls data from sql table with 40 million rows...so i created dataflow with same transformations and created a new pbi file with dataset connected to my dataflow. SO when i refresh the report, it showing me the size of that table as around 9GB ( as you can see the picture below where it shows 9.09GB for the 3rd table). But the pbi file size remains same. Why is it showing 9gb?
Another question, since the dataset is now connected to a dataflow which is already refreshed, now the refresh time has to be reduced but it is taking same time. Without dataflow it took me about 25 min to refresh., and after i conncted to dataflow, it is taking almost same time. It supposed to be very quick from wat i heard?
can anyone explain why ?
hi, @Anonymous
That should be the size of the query data.
and for refresh from dataflow, you may refer to this blog:
https://radacad.com/how-to-use-dataflow-to-make-the-refresh-of-power-bi-solution-faster
Best Regards,
Lin
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |