Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi community.
I´m working on my power bi but got stuck.
I added some information to my excel data. And when I opened the power BI and refresh the data, the Power BI is not reading the last 4 lines of my Excel.
I don´t think it´s a size limit problem, since my excel has 5000 rows and doesn´t weight that much. Also, my excel data is all in the same table, so I´m not sure why this is happening.
Hope to be clear enough and someone who had a similar problem can answer me.
Thanks
I have the exact same problem. 4 rows not shown every time. Should I create 4 dummy rows at the end?
No amount of refreshing will fix it.
Dummy rows worked although i know this is not a solution. I'm desperate.
Hmm, hard to say with more detail but it may be worth checking that your data has appended itself to the table correctly. Try clicking the data you entered in Excel... does the "Table Tools" pane appear in the ribbon?
The table should append automatically as you enter new data but there are cases where it does not happen.. Also try checking the source/Navigation of the query, sometimes you can import a worksheet instead of a table or vice versa.
If the data isnt a table then to turn the data into a table select all and Ctrl T... I find this more reliable than bringing in sheets.
Cheers
Greg
Hi
Thanks for you answer.
The data is all in a table. The strangest thing it that I´ve entered as new data 400 rows, and the power bi is reading all but the last 4 rows. I´ve resize the table, although it was including all the rows, and refresh the data on the report, but still doesn´t work
Mysterious... what's the total row and column count? I'll see if I can replicate.
Hi
It has 4962 row and 50 columns.
Does the new information have the same data type with original data? I have tested it on my local environment, we cannot reproduce this issue. In your scenario, you could create a new report and connect to this excel file and check if the new information exist on your data model or not.
Regards,
Charlie Liao
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |