Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Dataset becomes empty when a new csv column is added

I used "Get Data" and selected from a local csv file and therefore created a dataset. Next on Power BI desktop, I created a new report from that dataset. Everything works great with all changes in th...
Need Help
GilbertQ's avatar
GilbertQ
Super User
4 years ago

Hi Anonymous 

 

What typically happens when you connect to a CSV file is that it keeps a record of how many columns there were. And now when you update the CSV it will not show the extra column. You will need to go into Power Query and in the advanced editor you will see how many columns it has defaulted to.

 

if you are doing this via the Power BI Service and get data as it stands to day you will not be able to modify this.

 

You can vote for the idea on https://ideas.powerbi.com

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi GilbertQ, so this is a limitation of Power BI service? So a dataset sent there is fixed in structure and any changes subsequently will require a re-do of the whole reports? That's what I found and created two different datasets with the same problem. But I was hoping I was wrong. Thank you.