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 spreadsheet with 500.000 rows and 19 columns that I am trying to upload to PowerBI desktop.
When I upload there are only 65.000 rows.There is a way that I can upload all spreadsheet content?
Solved! Go to Solution.
As @Caitlin_Knox suggested, could you please create a measure like following one to check the actual rows imported to PBI Desktop?
Measure = COUNTROWS( 'TableName' )
I just tested with latest Nov 2017 version of PBI Desktop and I could import more than 65000 rows here.
Best Regards,
Herbert
As @Caitlin_Knox suggested, could you please create a measure like following one to check the actual rows imported to PBI Desktop?
Measure = COUNTROWS( 'TableName' )
I just tested with latest Nov 2017 version of PBI Desktop and I could import more than 65000 rows here.
Best Regards,
Herbert
Hi Herbert,
I couldn`t solve this issue. I removed Power Bi Desktop and installed again.
Now it is working and loading all data.
Thanks.
Are you seeing that row coutn in the query editor? Or did you use the COUNTROWS function to check your model? I know in the Query editor, it doesn't necessarily bring in all the rows right there. I would try adding a calculated measure to count the rows once you've loaded the data to the model from the editor.
Actually, it stops to load the data in 65.0000 rows.
I am construction Line and stacked column chart and that doesn't have the date after the 65.000 lines. Meaning that this data didn`t load.
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 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |