Forum Discussion
Power BI Service Refresh Stopped Working (Desktop Still Works)
Thanks for your quick response! I finally realized that my original data source was creating two columns called "task", which was causing the corruption. Thanks again!
**** I should mention that I've successfully done a refresh on the same file by uploading it to the Service through storage in Microsoft Teams. I didn't do Combine Files and just uploaded the single file, and was able to refresh in the Service. Makes me think it's related to using it as a sample file.
Other points, now that I'm thinking about it:
- If I try to use a "non-working file" (i.e., anything 12/14 or after) as the Sample File and filter the data to the "working files" (anything before 12/14) it will fail, however, if I use a 12/13 sample file for data on or before 12/13, it succeeds.
- If I try to use a pre-12/14 Sample File for any files later than 12/14, it will fail because of the added column at 12/14.
What do you mean by Working and not Working File?
In Blob Storage you have Excel files like this
with dates 20231213***, 20231211*** and you are trying to combine them in Power Query ? is it not?
if so these files, do they have the same structure?
Thanks for your quick response! I finally realized that my original data source was creating two columns called "task", which was causing the corruption. Thanks again!
