Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
VD209
Regular Visitor

Could not load data for visual

I am trying to upload certain files 

1. raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_seri...

2. raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_seri...

3. raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_serie...

 

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 hourThis is the problem after an hourthis is second attemptthis is second attemptthis is when i tried doing it with excelthis 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.

 

4 REPLIES 4
danextian
Super User
Super User

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.






Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu.

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🙏

some_bih
Super User
Super User

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.





Did I answer your question? Mark my post as a solution!

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

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.

Top Solution Authors