Forum Discussion
Issue importing data into Power BI Desktop
I am fairly new to Power Bi so any help is appreciated
I have a report that relies on an excel sheet with around 1200 rows (which I update monthly). These rows includue dates and currencies starting from 2021 until now. In the beginning I had no problems inputting in new data to the excel sheet and refreshing the data on Power Bi, as it would correspondlying update itself, but recently it has not been able too. I have my month updated but it only shows the first 9 days and Power Bi has no issues and neither does my excel sheet.
I looked at many of the discussions of restarting Power Bi, checking if the type of data was correct, making sure the excel sheet was closed and so on but none seem to work. In any case here is screenshots of what my data looks like and what I see on my Power Bi.
Hi neysha27
In your steps , you have 'remove bottom rows 'and 'change with Locale' steps, plese check that whether the rows are deleted in remove bottom rows steps and make sure the format in change with Locale is right.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
In the query you posted, I can see a "remove bottom rows" step. What is that doing?
Hi neysha27
In your steps , you have 'remove bottom rows 'and 'change with Locale' steps, plese check that whether the rows are deleted in remove bottom rows steps and make sure the format in change with Locale is right.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
