All the tricks I know for SUCCESS with Excel sources in Power BI
This video provides tips and tricks for working with Excel sources in Power BI. It covers optimization, file vs folder connectors, where the files should be stored, dataflows, and tips to avoid errors. The video also includes links to additional resources on incremental refresh, CSV vs XLSX performance, and query folding. The timestamps in the video are provided for easy navigation. Related videos on scheduling refresh on SharePoint sources, error handling, changing source file path to SharePoint, making a query filter not case sensitive, and using SharePoint lists as a data source are also mentioned. The video creator can be connected with through their blog and LinkedIn profile.
Video 5m
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time