Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I am trying to upload certain files
I am a beginner at powerbi and i took this power bi from edX offered by davidson college from where i got these exercise files for practice.
Now i took these links into my bi desktop and perform certain transformations and queries which are
1. Unpivoting the columns to form a date and value column
2. merging these tables to form one table
3. un enableing the two unneccessery tables
After these i try uploading it by hitting close and apply but i am getting very very huge Number of rows in million and millions and it is taking hours and hours and still not loading.
here are few ss of the problem.This is the problem after an hour
this is second attempt
this is when i tried doing it with excel
Ps;- I have corrected date column within My country format and stop include report refresh and still getting this.
Kindly Help with soultions
Thank you in Advance.
Hello,
Did you use merge or joining tables using keys instead of appending them to one another? I tested this in Excel myself and the tables loaded around 900k rows only. Attached is the Excel file.
Proud to be a Super User!
well, i merged the queries on country column when i tried appending them its giving null values as there is different columns and also the file u attched is not loading may be due to protected view.
thanx For taking out time to reply and help🙏
Hi @VD209 based on my experience Excel in not appropriate tool when you have millions of rows. To conform this in your case, backup your data source and data model files, delete data source rows to just few. This is also reason to go to Power BI.
In addition, before import data think why would somebody need so many millions of rows, meaning think how to aggregate it somehow and then import lower number or rows.
Proud to be a Super User!
Well I am trying to Figure that out as i am in beginner stages of learning powwr bi it is just that seeing so many rows got me overwhelmed.
But I'll trying aggregating it into a smaller dataset.
Thank U for taking some time to reply on this
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
72 | |
62 | |
51 | |
48 |
User | Count |
---|---|
206 | |
90 | |
61 | |
59 | |
57 |