Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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?
Solved! Go to 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.
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
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.
Yeah, that's weird.
Glad it works now.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
142 | |
79 | |
64 | |
52 | |
46 |
User | Count |
---|---|
213 | |
89 | |
77 | |
66 | |
60 |