Dave Power Query imports date values as plain text more often than expected, especially from CSV files, web sources, and databases with inconsistent schemas. Text-formatted dates break time intelligence calculations, prevent chronological sorting, and block date-based filters in both Power BI and Excel. Converting these text columns to proper date values requires the right combination of … Read more
Here’s a question i often encounter at work: I need to save some important videos from my Microsoft Teams chats, meetings, channels, as well as Microsoft Stream. How can I download these videos to my computer?” Save video files from Microsoft Teams to your computer Downloading videos from Microsoft Teams and Stream can be useful … Read more
Here’s a question from Dianne: I want to access my project management channel Teams files directly from File Explorer on my Windows 11 Computer. How can I map the files i store in my channels (mostly PowerPoint and Excel spreadsheets) to File Explorer? Are those kept on my hard drive? Mapping Teams file to Windows … Read more
Eddy asks: Why can’t I see the meeting chat history from my Teams meeting after it’s ended? Is there a way to keep the chat available?” Troubleshoot Teams chat persistence issues The issue you’re experiencing with Teams meeting chat disappearing is probably related to chat persistence settings. Let’s see how to fix this issue. We … Read more
Corey asks: As a team admin I need to change who’s in charge of our project channels. How do I keep the channel owner list fully updated – including adding and removing owning users as needed for the different panel. THis is absolutely critical as we are going through some restructuring. Our answer: Managing channel … Read more