cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Prodigy
Post Prodigy

Does PBI allow me load 12 field and one month later load additional 3 more new field ?

Hi All

During Sept i load in all field from CSV file and only keep 12 field , on Oct i like to load additional 3 more field can ?

Paulyeo11_0-1603865279104.png

 

3 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Super User IV
Super User IV

@Paulyeo11 , You have to open a Data transform/edit query. Right click on the table, open advance editor, and modify the code there as per need.

 

Keep a backup of file.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Highlighted
Memorable Member
Memorable Member

@Paulyeo11  Yes ofcourse  you can...The only thing to make sure  is not to change the source destination and refresh the .pbix desktop file you will be able to see the newly added rows.


Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.


Appreciate your Kudos, Press the thumbs up button!!👍

View solution in original post

Highlighted

@Paulyeo11 if you want to retain in the same location you can but in case if you change the location you will have to edit the data source setting in the .pbix else it will throw error "File not found"

Click on Home Tab-->Transform Data-->Data source settings-->follow the below screenshot
datasource.png

Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.


Appreciate your Kudos, Press the thumbs up button!!👍



View solution in original post

5 REPLIES 5
Highlighted
Super User IV
Super User IV

@Paulyeo11 , You have to open a Data transform/edit query. Right click on the table, open advance editor, and modify the code there as per need.

 

Keep a backup of file.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Highlighted
Memorable Member
Memorable Member

@Paulyeo11  Yes ofcourse  you can...The only thing to make sure  is not to change the source destination and refresh the .pbix desktop file you will be able to see the newly added rows.


Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.


Appreciate your Kudos, Press the thumbs up button!!👍

View solution in original post

Highlighted

Hi Hus,

Do you mean that i can not change the CSV file location , once i change the directory location from C:/Temp to C:/Test , it will not allow me to add more field name right ?

Paul Yeo

 

Highlighted

@Paulyeo11 if you want to retain in the same location you can but in case if you change the location you will have to edit the data source setting in the .pbix else it will throw error "File not found"

Click on Home Tab-->Transform Data-->Data source settings-->follow the below screenshot
datasource.png

Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.


Appreciate your Kudos, Press the thumbs up button!!👍



View solution in original post

Highlighted

Hi Amit 

Thank you very much.

I owe you too many beer.

Paul

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors