MSBI Tutor

In August 2021, we announced  general availability (GA) of backup and restore for large datasets . This Power BI feature closes an important gap to Azure AS. You can backup Power BI datasets on a regular basis to meet the data retention and disaster recovery requirements of your organization. You can also use this feature to migrate enterprise BI workloads from Azure AS to Power BI. Another common scenario is to roll back an existing Power BI dataset to a previous version. Yet, rolling back was not without challenges for large datasets near the max dataset size. But thanks to the latest improvements, you can now even restore a backup file when the dataset size is near the SKU limitation. You no longer need to be concerned that size limits impact restorability. For example, a P3 capacity has a max dataset size of 100 GB. If you wanted to maximize memory usage, you might have intended to host a dataset with 70 GB on this capacity. However, prior to the recent backup and restore improveme

We’re excited to announce that you can now embed entire Power BI organizational apps in Microsoft Teams tabs. Until now, this has been one of the top feature requests for Power BI integration with Microsoft Teams. It helps teams and organization put the full Power BI org app experiences directly where people work every day. By adding Org apps in channels and meetings, you enable everyone to access the data they need. We’ve started to roll out the experience to commercial cloud customers and expect it to be available for everyone in the next week or two. Let’s look at the new experience and its benefits. Picking an entire Power BI organizational app to embed in Microsoft Teams To embed a Power BI organizational app, add a Power BI tab to a channel or meeting. Go to the Apps pivot in the selection you and notice the  new checkbox next to the app name . When you check the box, you’re choosing to embed the entire organizational app in the Power BI tab.  If you don’t see an app in the list,

Welcome to the January 2023 Power BI Report Server release! This release has fun and exciting updates to features like the Report Server web portal, Modeling, and Reporting. Please read on for all the details, and feel free to leave your thoughts in the comments below. As always, we would love to hear from you! Report Server Accent color update .RDL and .PBIX file Migration Tool New .RDL report community Reporting Reverse stack order for stacked column charts Query performance improvements Indexing imported string columns on-the-fly Pushing Top N filter to DirectQuery sources Unshared and unsynchronized axes for small multiples charts Slicer type formatting moved to Format Pane Modeling DAX formula bar support for Desktop model view New DAX function: EVALUATEANDLOG New DAX functions: TOCSV and TOJSON Making it easier to do comparison calculations   Report Server Power BI Report Server accent color update Back in November 2022, Power BI announced the upcoming change in color accent to t

SELECT name AS ObjName        , crdate AS CreatedDate        , refdate AS RefreshDate        , CASE [TYPE]              WHEN 'AF' THEN 'Aggregate Function (CLR)'              WHEN 'C' THEN 'CHECK Constraint'              WHEN 'D' THEN 'Default or DEFAULT Constraint'              WHEN 'F' THEN 'FOREIGN KEY Constraint'              WHEN 'FN' THEN 'Scalar Function'              WHEN 'FS' THEN 'Assembly (CLR) Scalar-function'              WHEN 'FT' THEN 'Assembly (CLR) Table-valued Function'              WHEN 'IT' THEN 'Internal Table'              WHEN 'K' THEN 'PRIMARY KEY or UNIQUE Constraint'              WHEN 'L' THEN 'Log'              WHEN 'P' THEN 'Stored Procedure'              WHEN 'PC' THEN 'Assembly (CLR) Stored-procedure&