MSBI Tutor

Report authors often need date filters that automatically keep reports focused on the most relevant data without requiring ongoing maintenance. The new date picker slicer makes this easier by supporting dynamic relative date ranges that move forward as data refreshes, while still allowing report viewers to explore different date ranges, individual dates, and custom periods when needed.   Most reports have a date and report viewers want to see the latest data or pick their own date ranges. The date picker style of the slicer visual gives report authors and report viewers options to do it all.   Set up a relative range, such as last 30 days from the last date available. Anchor it on the last date, first date, or today with offset options to do last 30 days, starting 5 days back, if you want. This relative range automatically moves forward as your data refreshes and more data comes in. Publish the report and it’s the default relative range.   Your report viewers remain free ...

When enabling Microsoft Entra ID single sign-on (SSo) for Starburst (Preview) report viewers querying semantic models in DirectQuery mode authenticate to Starburst with their own Entra ID identity, to Starburst's access policies — including row-level and column-level security rules — are evaluated against the actual end user rather than a fixed connection account.   Two connectors, one to use The Starburst connectors are built and maintained by Starburst. Two Starburst entries appear in the Power BI Get Data list. The original Starburst connector remains available for existing reports, but the new SSO experience ships in the Starburst secured by Entra ID connector — pick this one for any new report where you want Entra identities to flow end-to-end, as in the following screenshot.   Figure: The Starburst secured by Entra ID connector.   How it works The Starburst secured by Entra ID connector supports both Import and DirectQuery semantic models through the on-premises d...

Workspace outbound access protection (OAP) is a workspace-level control in Microsoft Fabric that lets you constrain where the data inside a workspace can flow. With this preview, OAP support now extends to Power BI reports. The good news for report authors and admins: there's nothing new to configure on the report itself. Protection comes from a single, well-defined rule that the workspace enforces automatically as soon as you turn OAP on. Why it matters Power BI reports don't carry their own data connections. They're bound directly to a semantic model. That binding isn’t always obvious when you’re reasoning about data boundaries — a report sitting in a sensitive workspace might bind to a semantic model in another workspace. Such a report mostly retrieves data from its semantic model (an inbound flow), but filter values, such as those specified using query string parameters in the report URL, would flow outbound across the data boundary.   Before OAP, a workspace admin had ...

Connecting Power BI to Oracle has historically meant extra provider installations and data gateway deployment — even for cloud-hosted databases. Two new Preview capabilities change that. Power BI Desktop now includes a bundled Oracle Managed ODP.NET provider, and the Power BI service supports direct cloud connections without the need for a data gateway to Oracle data sources such as Oracle Autonomous Database. How it works in Power BI Desktop Power BI Desktop ships with the Oracle Managed ODP.NET provider built in. To turn it on, go to File > Options and settings > Options > Preview features and enable both switches: Enable using Bundled Oracle Managed ODP Provider for Import Mode Enable using Bundled Oracle Managed ODP Provider for DirectQuery Mode Figure: Enabling Oracle preview features.   Restart Power BI Desktop, then connect to your Oracle database through the existing Oracle database connector. Both Import and DirectQuery work without any additional client installat...