Archiving techniques to speed up refresh

Archiving techniques to speed up refresh

Wyn Hopkins Wyn Hopkins

Wyn Hopkins

Solving data challenges for companies and people. Power BI | Excel | Fabric | Solver Budgeting & Consolidation. Part of the Amazing team at Access Analytic Microsoft MVP ??6 Million+ YouTube views

发布日期: 2022年5月24日
+ 关注

If you are using a SharePoint or OneDrive Folder as a data source for your Power BI or Excel reports then the more files you add the longer the refresh will take.

One solution is to periodically archive your older files into a consolidated table

I demonstrate 2 techniques:

1. Using https://bravo.bi/ to create a CSV consolidation

2, Using Dataflows in Power BI


you could also use the DAX Studio add in for Excel and follow a process similar to the one I demonstrate here...https://youtu.be/op6f-3uUFYg

I mention my video on the use of SharePoint.Contents https://youtu.be/-XE7HEZbQiY

Wyn

No alt text provided for this image
Mandar Zanpure

Project Manager @ KPIT | Project/Program Management | PMP? | PMI-ACP? | SAFe Scrum Master & Practitioner | Six Sigma Green Belt | MBA |

2 å¹´

Shashank Saxena

赞
回复
Remy Spanjaard

Business & Data Consultant

2 å¹´

Ma?gorzata Szantyr Nikhitha Ashaboina SHIVA KUMAR NT

赞
回复
查看更多评论

要查看或添加评论，请登录

Wyn Hopkins的更多文章

  • PowerToys
    2025年3月25日

    PowerToys

    PowerToys is one of the most underrated free tools available for Windows users. Developed by Microsoft, this suite of…

    3 条评论
  • The Best Dependent Drop Down Technique
    2024年11月15日

    The Best Dependent Drop Down Technique

    Driven by a gauntlet laid down by friend and fellow MVP Mark Proctor on our Unpivot podcast recently I revisited my…

    1 条评论
  • Should you use Measures for Conditional Formatting?
    2024年6月9日

    Should you use Measures for Conditional Formatting?

    Streamline Your Power BI Conditional Formatting with Measures I've always found the built-in conditional formatting in…

    6 条评论
  • Consolidate and Hyperlink to Excel files on SharePoint
    2024年1月3日

    Consolidate and Hyperlink to Excel files on SharePoint

    In this video, we're diving into the world of Excel and Power BI, focusing on creating hyperlinks for easy referencing…

    4 条评论
  • The greatest multi-level Excel drop-down list ever!
    2023年11月3日

    The greatest multi-level Excel drop-down list ever!

    One-Off dependent drop down lists in data validation are relatively straightforward: here's a technique using XLOOKUP…

    5 条评论
  • Default Your Slicer to the Current Month in Power BI
    2023年7月31日

    Default Your Slicer to the Current Month in Power BI

    First Published November 2022 on our YouTube Channel Join 65,000+ subscribers to stay up to date with new videos…

    4 条评论
  • Power BI Licensing Explained
    2023年5月27日

    Power BI Licensing Explained

    What are the differences between: Power BI Free (soon to be renamed Fabric Free) Pro: $10 USD pp/pm PPU (Premium Per…

    2 条评论
  • Power BI May 2023 Release
    2023年5月26日

    Power BI May 2023 Release

    The May version of Power BI desktop is out This is a very quick post highlighting my 2 favourite picks: 1. Azure Maps…

    5 条评论
  • Simpler DAX ? = Power Query
    2023年5月12日

    Simpler DAX ? = Power Query

    If you are struggling to write a complicated DAX formula then the answer may be to step back and do a little Power…

    2 条评论
  • Power BI Explained
    2023年3月29日

    Power BI Explained

    A simple explanation of Power BI I hope you find this useful. Power BI continues to go from strength to strength and…

社区洞察

其他会员也浏览了