Back

Explore Courses Blog Tutorials Interview Questions

Power BI - Data refresh doesn't work for CSV File

0 votes
2 views
in BI by (17.6k points)

I am currently loading a local CSV file. If I add a column/row in the file, I want to refresh the data in my power bi. If I press refresh in the Query Editor, nothing happens. Do you have any ideas on why that isn't working?


EDIT

It works perfectly for MS Excel but doesn't work for CSV. Why? 

1 Answer

0 votes
by (47.2k points)

Open the advanced editor, then you will find the original number of columns that are defined. Delete that number so that it will work.

Want to learn more about Power BI, Come & join Power BI tutorial. Also, enroll in Power BI course online to become proficient in this BI tool.

Related questions

0 votes
1 answer
Visualizing last refresh date in power bi
asked Jul 9, 2019 in BI by Vaibhav Ameta (17.6k points)
0 votes
1 answer
Display related data when filtered in Power BI
asked Jul 12, 2019 in BI by Vaibhav Ameta (17.6k points)
0 votes
1 answer
Power BI Pro limitations
asked Dec 21, 2020 in BI by Chris (11.1k points)
0 votes
1 answer
Fiscal year in power bi
asked Dec 1, 2020 in BI by Chris (11.1k points)

Browse Categories

© COPYRIGHT 2011-2023 INTELLIPAAT.COM. ALL RIGHTS RESERVED.

Download Salary Trends Now !

Learn how professionals like you got up to 100% Salary Hike.

...