Forum Discussion
SharePoint
Anonymous Instead of creating a PBI report from scratch, you can try bringing in the files in the folder in a new PBIX file and if it works there, then copy everything from the "advance editor" to your original file and replace the existing one and see if it works.
As you said, format of the excel spreadsheet has changed and hence, there might be some disconnect which powerBi might be unable to notify you about.
Hi Liu,
Thank you. The issue is that the format of my Excel spredheet changed, I have added new columns, removed other. I thaught that I could just start fresh so I thaught that if Ichane the name of the spreadhseet I could just start fresh with the new spreadsheet, but PBI refuses to aknowledge the new file. It doesn't see it.
Should I then create my PBI Report from scratch or is there a way around it?
Thank you kindly,
JT
Anonymous Instead of creating a PBI report from scratch, you can try bringing in the files in the folder in a new PBIX file and if it works there, then copy everything from the "advance editor" to your original file and replace the existing one and see if it works.
As you said, format of the excel spreadsheet has changed and hence, there might be some disconnect which powerBi might be unable to notify you about.
Hi LP280388
I have opened a brand new PBI Session - Get Data - SharePoint Folder - Copy & Insert Site URL - Transform Data - I Filter Extansion Column to display only xlsx. files as my file is that. - Folder Path - Load More
The new file is not showing. I don't understand.
Any further suggesions please?
Many thanksHi LP280388
I figured it out! Yeah! The file was just not showing, nowewhere to be found, so I sorted the column Asc. and it's there!!! i guess it needed a little refresher of a sort.
Thank you for your assistance.
Kindest regards,JT