Видео

This video walks through a useful tool to quickly review a VPAX file from a Power BI semantic model, and provide recommendations to the model creator. Link to Model Reviewer - github.com/hoosierbi/fileshare/tree/main/ModelReviewer Instrucitons to generate a VPAX file - ruclips.net/video/ke5tsoyzkBQ/видео.html

This video walks through strategies to leverage multiple Fabric capacities to protect your priority content from throttling.

This video shows an example of taking data snapshots from a Power BI semantic model with a Fabric notebook. It also provides a solution to create Direct Lake model with data from the Fabric Capacity Metrics App, which offers a summarized view of all your capacities with long-term data storage. Solution Files github.com/hoosierbi/fileshare/tree/main/MetricsAppSnapshots

This videos explains two valuable shared dimensions to create for your company - date table and people table. The options to create and consume these shared dimensions is the demonstrated.

This video walks through three example Power Automate flows that can be used to pause/resume or resize your Fabric capacity on a schedule, or to dynamically resize your capacity based on a query results from the capacity metrics app. Zip files for import - github.com/hoosierbi/fileshare/tree/main/CapacityFlows

This video shows how to use pause, resume, and/or resize your Fabric F SKU capacity with a Power Automate flow.

This video shows two alternate ways to handle field parameters selections in the Deneb Power BI visual. One of the two enables multiple field selections. An approach to leverage calculation groups to give "none selected" behavior or to limit the number of fields that can be selected is also shown.

This video walks through how to trigger a Fabric notebook from a Power Automate flow to enable event-triggered notebook runs. It also briefly shows how to refresh a Dataflow Gen 2 from a flow too. Links mentioned in flow learn.microsoft.com/en-us/fabric/data-engineering/notebook-public-api forwardforever.com/calling-an-api-using-entra-id-authentication-in-flow/ www.bertverbeek.nl/blog/2024/01/1...

This video walks through several examples of how calculation groups can be used to protect you model/capacity from expensive unneeded queries from your report visuals. The same technique can be used to get default selections behavior from slicers.

This video goes through the Fabric Capacity Metrics App (version as of Jan 2024) with tips to help monitor and troubleshoot your Fabric capacity.

This videos walks through several options to send data/reports to multiple files/emails from a Power BI model using Power Automate. The data can be sent as csv files, or to prebuilt Excel files using office scripts. Approach adapted from this video by Damien Bird - ruclips.net/video/gtlklzi6MDg/видео.html

This video shows how to use a Power Automate flow to help monitor the throttling delay/rejection on a Fabric capacity. Link to zip to import flow - github.com/hoosierbi/fileshare/tree/main/CapacityChecker

This video shows a variation on a previous video where URLs with filters are bursted to report subscribers instead of rendering the reports in the flow. Link to folder with zip file to import flow - github.com/hoosierbi/fileshare/tree/main/PaginatedReports

This video walks through a Power App for report consumers to subscribe to multiple reports in a single interface. The related SharePoint lists and Power Automate flow are also described. Folder with zip files to import the app and/or flow - github.com/hoosierbi/fileshare/tree/main/PaginatedReports

Custom Paginated Report Subscriptions With Power Automate

Custom or Weekly Partitions With Power BI Incremental Refresh

Generating lists of random numbers from normal/gaussian distributions with Power Query

Removing a variable number of first rows in Power Query

Intro To Low Code Custom Visuals in Power BI

Options for Simple LInear Regression in Power BI

Options to Display Images In Power BI

Leveraging Field Parameters with the Deneb Power BI Visual

Options for Dynamic Text with the Deneb Power BI Visual

A useful "play-taset" for learning and troubleshooting Power BI

How to deal with a slow matrix visual in your Power BI report

How to troubleshoot a slow matrix/table visual in Power BI

Date Table Tips

Incremental Refresh with SharePoint Files

Handling Ties with TOPN