Effective Cloud Governance: Leveraging Azure Activity Logs with Power BI
We all generally accept that governance in the cloud is a continuous journey, not a destination. There's no one-size-fits-all solution and depending on the size of your Azure cloud estate, staying on top of things can be challenging even at the best of times. One way of keeping your finger on the pulse is to closely monitor your Azure Activity Log.This log contains a wealth ofinformation ranging from noise to interesting to actionable data.One could set up alerts for delete and update signals however, that can result in a flood of notifications. To address this challenge, you could develop a Power Bi report, similar to this one, that pulls in the Azure Activity Logand allows you to group and summarize data by various dimensions.You still need someone to review the report regularly however consuming the data this way makes it a whole loteasier.This by no means replaces the need for setting up alerts for key signals, however it does give you a great view of what's happened in your environment. If you're interested, this is the KQL query I'm using in Power Bi let start_time = ago(24h); let end_time = now(); AzureActivity | where TimeGenerated > start_time and TimeGenerated < end_time | where OperationNameValue contains 'WRITE' or OperationNameValue contains 'DELETE' | project TimeGenerated, Properties_d.resource, ResourceGroup, OperationNameValue, Authorization_d.scope, Authorization_d.action, Caller, CallerIpAddress, ActivityStatusValue | order by TimeGenerated asc
Help In Editing Data Source Credentials in PowerShell for Power BI Embedded Dashboards in D365 CRM
Hello, We are currently migrating Power BI embedded dashboards from one Dynamics 365 CRM tenant to another. The process involves creating a new Power BI report within a workspace. Since the Dynamics 365 Solution does not support the inclusion of Power BI reports within unmanaged solutions, we have resorted to using PowerShell scripting to manage the migration. During this migration, we encountered an issue where the report IDs from the original environment remained linked when moving the Power BI embedded dashboards to the new environment. To address this, we have utilized Environment Variables to map the new report and workspace IDs appropriately. However, we are facing an issue when attempting to edit the Data Source Credentials using PowerShell scripting. Specifically, we are receiving a "Bad Request" error, as shown in the screenshot below. Here is the PowerShell code we are currently using to edit the Data Source Credentials: Connect-PowerBIServiceAccount $accesstoken = Get-PowerBIAccessToken $patchBody = '"credentialDetails": { "credentials": {"accessToken":"'+$($accesstoken)+'"}, "encryptedConnection": "Encrypted", "encryptionAlgorithm": "None", "privacyLevel": "Organizational", "useEndUserOAuth2Credentials": true }' Invoke-PowerBIRestMethod -Url "https://api.powerbi.com/v1.0/myorg/gateways/9eaed562-e9c2-46e4-91cf-276ed0947b41/datasources/f1181856-de29-4a9a-a555-a0e181cd7898" -Method Patch -Body $patchBody We would greatly appreciate any guidance or suggestions on resolving this error in the PowerShell scripting process for updating the Data Source Credentials. Thanks! Inogic Professional Services: Power Platform/Dynamics 365 CRM An expert technical extension for your techno-functional business needs Drop an email at email address removed for privacy reasons Service: https://www.inogic.com/services/ Tips and Tricks: https://www.inogic.com/blog/Join the Fabric Partner Community for this Week's Fabric Engineering Connection calls!
Are you a Microsoft Partnerthat is interested in data and analytics? Be sure to join us for this week's Fabric Engineering Connection call, now offered at two different times! 🎉 Tamer Farag will be joining both calls to discuss the latest and greatest related to partner offerings and updates, including certifications, Fabric Featured Partners, trainings, incentives, and more. The Fabric Engineering Connection call taking place Wednesday, January 15, from 8-9 am PST. The APAC Fabric Engineering Connection call taking place Thursday, January 16, from 1-2 am UTC/Wednesday, January 15, from 5-6 pm PST. This is your opportunity to learn more, ask questions, and provide feedback.To join the call, you must be a member of the Fabric Partner Community Teams channel.To join, complete the participation form athttps://aka.ms/JoinFabricPartnerCommunity. We can't wait to see you this week!
Field Parameter when used in filter pane not working for TOPN filters
Hi, I have created a visual as below: Now I want to filter this visual by bottom 10 worst performers Site Name by Variance parameter created. FYI the variance Field parameter table shown below: So I dragged that field parameter column into filter on this visual 'By value'. But its not showing top10 or bottom 10 instead it is showing all site name. Please advise! PFA file here Portfolio Performance - v2.15 (1) - Copy.pbix Thanks in advance Sir! SergeiBaklan
Microsoft In a Day (XIAD) Partner Events Program - Train the Trainer Events (FAIAD/RTIAD)
We invite you to attend an upcoming Train the Trainer session for Microsoft Partners to learn more about theMicrosoft In a Day (XIAD) Partner Events Programand how to lead workshops that empower customers to use and adopt Microsoft products. Our Train the Trainer events are designed to provide you with the knowledge and tools necessary to deliver successful Microsoft In a Day (XIAD) sessions. ✨Why Attend? Hands-On Experience:Participate in labs and demos just like customers will. Expert Guidance:Learn from experienced trainers and get your questions answered. Comprehensive Resources:Access all the content and support you need to succeed. 📅Upcoming Events: Fabric Analyst in a Day (FAIAD) Friday, January 24, 2025 | 9:00 AM – 5:00 PM (GMT-06:00) Central Time Fabric Analyst in a Day (FAIAD) Friday, February 14, 2025 | 9:00 AM – 5:00 PM (GMT+01:00) Central European Time Real-Time Intelligence in a Day (RTIAD) Friday, February 28, 2025 | 9:00 AM – 5:00 PM (GMT-06:00) Central Time Real-Time Intelligence in a Day (RTIAD) Friday, March 14, 2025 | 9:00 AM – 5:00 PM (GMT+01:00) Central European Time Once registered, look for your registration confirmation email fromnotification@msftevents.microsoft.comthat containsyour unique Teams meeting link to join the virtual event. Be sure to check spam and junk folders, and mark as a safe sender. If you are unable to locate your registration confirmation, emailpappspartnerevents@microsoft.com. We look forward to seeing you at an upcoming event! Are you a Microsoft Partner interested in the opportunity to join the program and deliver Microsoft In a Day (XIAD) events? 🔍 Learn more about the program and review partner eligibility criteria:https://aka.ms/xiadpartneropportunity. 📧 Contact the XIAD Program team:xiadevents@microsoft.com 📤 Submit requests to deliver events:https://aka.ms/xIAD/PartnerEventsWhat’s Included with Microsoft’s Granted Offerings for Nonprofits?
Are you a nonprofit looking to boost your impact with cutting-edge technology? Microsoft is here to help! From free software licenses to guided technical documentation and support, this program offers a range of resources designed to empower your organization. In this blog, we’ll dive into the incredible tools and grants available to nonprofits through Microsoft, showing you how to make the most of these generous offerings. Whether you’re managing projects or just trying to simplify your day-to-day tasks, there’s something here for everyone. Let’s explore what’s possible!Join the Fabric Partner Community for this Week's Fabric Engineering Connection calls!
Are you a Microsoft Partner that is interested in data and analytics? Be sure to join us for this week's Fabric Engineering Connection call, now offered at two different times! 🎉 The Fabric Engineering Connection call taking place Wednesday, January 8, from 8-9 am PST will feature presentations from Miguel Llopis on recently shipped and upcoming Data Factory features and Misha Desai on Data Science. The Fabric Engineering Connection call taking place Thursday, January 9, from 1-2 am UTC/Wednesday, January 8, from 5-6 pm PST will feature presentations from Emily Chen and Leo Li on recently shipped and upcoming Data Factory features and Misha Desai on Data Science. This is your opportunity to learn more, ask questions, and provide feedback. To join the call, you must be a member of the Fabric Partner Community Teams channel. To join, complete the participation form athttps://aka.ms/JoinFabricPartnerCommunity. We can't wait to see you this week!Receiving Error After Unpivoting Columns in Power Query
I'm trying to alphabetize a column of email addresses, separated by a semi colon. I found if I added an index column, split by delimiter, unpivoted the columns, sorted the rows, grouped the rows, and then add a custom column combining the data, I was able to achieve this. However, coming back to it today, it no longer works and is throwing a DataFormat.Error: Invalid cell value '#NAME?' error. After messing around with adding different steps to see if I kept getting the error, I noticed that no matter what I added after the Unpivoted Columns step, I will get this error. I did some research and it seemed that it was a type error so I switched all types by using "Detect Data Type". This still did not work. I also tried replacing all the nulls from splitting by delimiter and all blank cells with "Null" (not sure if there was any but wanted to be thorough). I turned on "Column quality" to see where the error was coming from and I'm getting 100% valid on all columns My code: let Source = Excel.CurrentWorkbook(){[Name="ACR"]}[Content], #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]), #"Filtered Rows" = Table.SelectRows(#"Promoted Headers", each ([Type] = "Assets" or [Type] = "Links")), #"Replaced Value" = Table.ReplaceValue(#"Filtered Rows"," ","",Replacer.ReplaceText,{"ContentOwner"}), #"Added Index" = Table.AddIndexColumn(#"Replaced Value", "Index", 1, 1, Int64.Type), #"Split Column by Delimiter" = Table.SplitColumn(#"Added Index", "ContentOwner", Splitter.SplitTextByDelimiter(";", QuoteStyle.Csv), {"ContentOwner.1", "ContentOwner.2", "ContentOwner.3", "ContentOwner.4", "ContentOwner.5"}), #"Changed Type" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"SiteCollection", type text}, {"Site", type text}, {"ContentId", Int64.Type}, {"ContentOwner.1", type text}, {"ContentOwner.2", type text}, {"ContentOwner.3", type text}, {"ContentOwner.4", type text}, {"ContentOwner.5", type text}, {"Title", type text}, {"Index", Int64.Type}}), #"Replaced Value1" = Table.ReplaceValue(#"Changed Type",null,"Null",Replacer.ReplaceValue,{"ContentOwner.2", "ContentOwner.3", "ContentOwner.4", "ContentOwner.5"}), #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Replaced Value1", {"SiteCollection", "Site", "ContentId", "Title", "Index"}, "Attribute", "Value"), #"Sorted Rows" = Table.Buffer(Table.Sort(#"Unpivoted Columns",{{"Index", Order.Descending}, {"Content Owner", Order.Ascending}})) in #"Sorted Rows" Note: I tried to moving the Changed Type step to after the Unpivoted Columns step and I still receive the same error. I used Table.Buffer here because the grouping did not maintain the sort I specified on this step. Once I added Table.Buffer, it did. I removed it in trying to solve this problem and I still get the error. View when on the Unpivoted Columns step: Due to the nature of the data, I cannot share the file so if there is any clarification I can provide, please let me know.
All the rows after last "8" in PQ
Dear Experts, Can you please help on how to get a column for all the elements after Last-8 in below Table ( not sure of we can use Table.LastN to do this, but without M-code:- So, in the New Column, I should have, ,6,15,4,..12 Using UI, Thanks in Advance, Br, Anupam
