Please enter your information to subscribe to the Microsoft Fabric Blog.

Thanks for subscribing to the Microsoft Fabric Blog. You’ll receive email notifications when we publish new posts.

Microsoft Fabric Updates Blog

  1. Updates
  2. Support

Tech Tip Thursday: Dynamic Power BI reports using Parameters

Microsoft's Guy in a Cube has been providing tips and tricks for Power BI and Business Intelligence on their YouTube channel since 2014. Occasionally on Thursdays we highlight a different helpful video from the collection.

Did you know that you can dynamically filter data in Power BI using parameters that are stored in an Excel workbook? In this video, Patrick from Guy in a Cube shows us how, using M Functions within Power Query and a gateway to enable data refresh. Check it out!

Related blog posts

Tech Tip Thursday: Dynamic Power BI reports using Parameters

Blog's featured image

Troubleshooting automatic aggregations to optimize DirectQuery performance
October 9, 2023 by Kay Unkroth

We have some very exciting news to share with you today! We are thrilled to announce that we have just launched the public preview of Direct Lake mode for Power BI datasets in Fabric! Fabric is taking a bold bet on open data formats in OneLake.

Read more
Blog's featured image

Announcing backup and restore improvements for large datasets near the size limit
January 23, 2023 by Kay Unkroth

Thanks to the latest backup and restore improvements, you can now restore a backup file even when the dataset size is near the Power BI Premium SKU limitation. You no longer need to be concerned that dataset size limits impact restorability. When restoring a dataset with the /forceRestore option, Power BI will try its best to perform the restore operation even when the available memory is limited.

Read more