Data Refresh - Data Not Updating

[PowerBINoob24]

Hello,

I have a report that pulls data from an excel spreadsheet.  One of the columns is "Name"  Every time I've updated the spreadsheet and refreshed the data in desktop there has been no issues.

Recently I updated the data in the "name" with an "(A)" or "(T)" designator so I can use a DAX formula to categorize names.  The problem is now when I go to refresh the data in desktop the data in the Name column doesn't update.  I can see the updated data in the source spreadsheet, I watch the record count when I refresh and that is correct.  What am I missing?  I feel like I need to clear a cache somewhere or something like that.

Thoughts?

[HughLa]

Hi @PowerBINoob24 

Did you add the (A) or (T) to each row of the Name column? 

Have you tried to create a new query to that file and see if it loads the data correctly? It might be something in your Power Query as well. 

Hugh

[PowerBINoob24 · Accepted solution]

Yep.  Those were added to each row.  Must have been something with the connection.  My test files are local, the production files are in a sharepoint folder.  I pointed back to my test files and it picked up the changes.  Pointed it back to the production files and it started picking it up.  Weird.

[HughLa]

Yeah, that's weird.

Glad it works now.