Blogs

Be the first person to recommend this.
Goals of this Post Use Calculation Groups Use Tabular Editor Advanced Scripting Speed up SSAS/PowerBI model development Create reusable script Setting up the Environment Power BI: Download here . Tabular Editor: Download here . SQL Server 2019 or Azure Analysis Services or power bi with external tool. (July 20 or later) Calculation Groups I'm not going to repeat all the technical details that Microsoft has already nicely written  here . The goal of this post is to show another approach on how to use the calculation groups and demonstrate why you may prefer to use this alternative approach instead of ...
0 comments
1 person recommends this.
Power BI Sidetools is a free Power BI external tool intended to increase productivity during reports development in Power BI desktop. Transfer DAX and M formulas to files With just one click, you can transfer M and DAX formulas in a folder named like your report. The very first use case will be probably to save your different versions in backups. Right click on your report name and select "Send to/Compressed folder". View your DAX and M formulas in Visual Studio Code With just one click, you open Visual Studio code to view your DAX and M formulas. Visual Studio Code is a lightweight but very powerful free source code editor created ...
0 comments
Be the first person to recommend this.
Greetings, I have a flow that was running well with the D365 connector, however after MS deprecated the connection, I have been unable to get the common data service connector to find my custom entity "Covid-19 Call Report". { "status" : 404 , "message" : "Table with name 'Covid-19 Call Report' does not exist" , "error" : { "message" : "Table with name 'Covid-19 Call Report' does not exist" }, "source" : "commondataservice-cus.azconn-cus.p.azurewebsites.net" , "debugInfo" : "clientRequestId: 0d19eb54-4fb1-48f0-b5f8-1cff78ebb2bc" }
0 comments
Be the first person to recommend this.
Community Summit Europe 2020 was one for the books – thought-provoking, innovative, and for the first time…100% virtual. The circumstances of COVID-19 posed new challenges and prompted necessary new approaches to how we gather and learn. Pre-COVID-19, the Community Summit experience could be described as nothing short of memorable, inspiring and connected – a powerful energy felt by all when the community came together, and all the interactions we took for granted that accompanied these great gatherings. This included recognition and celebration of our outstanding volunteers, special moments typically reserved for these marquee events. While we couldn’t ...
0 comments
Be the first person to recommend this.
While working on a project at work, I came across a very interesting issue with a Microsoft PowerApps and Power Automate. A number of you probably already know this, but if you trigger a Power Automate Flow from a button within a PowerApps app, the Flow retains the context of the user account that  triggered the Flow and not the user account that was used to create the Flow. In most instances this is fine, but what happens when you trigger an approval workflow, that needs to update the content approval status of a list item? It would mean everyone would need an elevated level of access to the SharePoint list. What  if that was not an option? What if you only ...
0 comments
Be the first person to recommend this.
@Reza Rad   and @Leila Etaati  are both Microsoft MVPs, User Group All Stars & Academy instructors, well-known international speakers, best-selling authors, and avid bloggers about the Microsoft Power Platform - the true definition of a 'Power Couple'.  Dynamic Communities (DC): Leila, you were the first Microsoft AI MVP in New Zealand and Australia. What does that mean to you? Leila Etaati (LE): I was energized (and still am) by anything AI. Even the time that I was Data Platform MVP, I always did the data science and AI parts of it, and evangelized those parts. That led me to become the first AI MVP or let’s say double-sided ...
0 comments
Be the first person to recommend this.
Dear Dynamic Communities Members:   I hope you and your families are safe and healthy in these challenging times. As we all face the uncertainty of a COVID-19 world, we want to connect and share some important updates with our community members.   First, on behalf of the Dynamic Communities team, thank you. The onset of Covid-19 in March brought an unprecedented impact to community members around the world, and we want you to know how much we appreciate the users, partners and organizations who make up our diverse global community. We are listening. We understand the personal and professional challenges you are facing, and we will continue to be here ...
0 comments
Be the first person to recommend this.
If you are just getting started with Power BI you may be seeing a lot of references to a 'Calendar' Table or 'Date Table.  Maybe you already have a handle on this aspect of PBI, but a lot of people seem not to understand how to get started.  If you forego having a 'Calendar' Table altogether, you can end up having a very cumbersome file and you won't be able to take advantage of many of the awesome date/time functions offered through Power BI.  There are quite a few good resources already out there.  This post points you to a few of those and helps you get started in both M and DAX. To turn off Time intelligence - here is a great blog resource:  sqlbi - DAX ...
1 comment
Be the first person to recommend this.
Register for our no-charge webinar series to learn how to protect yourself from being a a target of cyber threats! With over 164.68 million sensitive records exposed in 2019, there has never been a greater need for cyber security training. There are news stories published almost daily about data breaches and identity theft. To address this community need, Dynamic Communities has partnered with industry experts in the cyber security world to provide valuable information on how to protect your organization from cyber crime attacks. Join us for a tapas-style (small bits of learning on various topics), no-charge webinar series June 8-10, 2020. Cyber ...
0 comments
Be the first person to recommend this.
Register for our no-charge webinar series to learn how to protect yourself from being a a target of cyber threats! With over 164.68 million sensitive records exposed in 2019, there has never been a greater need for cyber security training. There are news stories published almost daily about data breaches and identity theft. To address this community need, Dynamic Communities has partnered with industry experts in the cyber security world to provide valuable information on how to protect your organization from cyber crime attacks. Join us for a tapas-style (small bits of learning on various topics), no-charge webinar series June 8-10, 2020. ...
0 comments
Be the first person to recommend this.
What's your type? For a beginner in Power BI and in business intelligence in general, it is not easy to understand data types and differentiate them from data format. And then comes data category... So, what's all that about, really? It's true that in spreadsheet applications like Excel, data type is not really of a bother to the user, as there is no functionality to define the type of the data present in cells. We just enter values and it's all fine (somehow). In fact, I only started to bother about data types when starting to use Power Query, Power BI and Power Pivot (data modelling tool in Excel). Power Query is less friendly with typeless (or rather ...
0 comments
Be the first person to recommend this.
https://www.kaispe.com/generate-lead-record-in-microsoft-dynamics-crm-through-web-contact-form-using-ms-power-automate
0 comments
Be the first person to recommend this.
If we want to perform multiple actions Common Data Service at once , like creating/ updating 100 different records, Flow will make many different calls to CDS. Although it works fine, but it takes lot of time and keeping   limitations on number of requests   , this might not be a good approach. But, no worries , Microsoft is going to solve this by introducing   “Batch”   concept in flow. We can add a  Batch  scope to your flows that will group all these different operations into a single call to Common Data Service to dramatically improve performance. To use this, search for  Batch  under the  Common Data Service  connector. Once you add this ...
0 comments
Be the first person to recommend this.
I have come across a requirement to trigger flow when a record is updated and one of the fields contains data. We can achieve this using condition action . But there is a better way to do it using   Trigger Condition   setting in Power Automate and   functions  provided by the  Workflow Definition Language . Here are the steps. Step 1 :   Navigate to settings area. Step 2 :   Go to   Trigger Condition   and click on   Add Step 3 : Add condition to check if field contains data. Like this , multiple conditions can be added. And we can even use expressions like   and,or   to check multiple conditions. For more information about ...
0 comments
Be the first person to recommend this.
No matter how great we are in programming , sometimes our code has errors. They may occur because of our mistakes, an unexpected user input, an erroneous server response, and for a thousand other reasons. So handling these exceptions is very important . Anyone who has even a little experience with programming knows the   “try – catch”   to handle these exceptions. The same approach can be used in Power Automate / Flow to handle exceptions. In fact, we have a template in Power Automate templates gallery and it can be used straight away. https://flow.microsoft.com/en-us/galleries/public/templates/e8e028c6df7b4eb786abdf510e4f1da3/try-catch-and-finally-template/ ...
0 comments
Be the first person to recommend this.
Recently , I have come across this issue with Power Automate while I am trying to create a record using “Create a new record ” action with Common Data Service(Current environment) connector based on some trigger. I am not doing any complex stuff, just creating a quote line record and referencing a quote record. Referencing records is as simple as using dynamic content and populating it to a lookup attribute right !!! No, its not. Let’s see. I just run the flow with the above setup and flow run got failed with  “Resource not found for the segment ‘c262238e-fc89-ea12-ba11-000d3ab615df'” After some digging , found the cause. The new   CDS ( ...
0 comments
Be the first person to recommend this.
Hi Friend,  When New York was first picked as a stop on the Power Platform World Tour ,  the topic of how the Microsoft Power Platform was being used to influence change in the NY Taxicab system seemed fitting. Although Dynamic Communities has made the decision to take a virtual approach to this event to ensure the health and safety of our community, we still find value in sharing this story about big data and Power BI. Power BI Reporting and Integration with Azure Synapse Analytics Meet Jared Brown  and  Kenneth (KC) Philcox   from  Tallan – two guys who certainly get data and analytics. Their story is something you need to see ...
0 comments
Be the first person to recommend this.
See how can we use Azure Machine Learning services with Microsoft Power Automate https://www.kaispe.com/developing-custom-connector-in-ms-power-automate-using-azure-ml-services/
0 comments
Be the first person to recommend this.
Automation has always been a key to businesses to achieve higher productivity and lower the operating cost by avoiding repetitive tasks. With recent situation where social distancing is playing a major role handling the pandemic, businesses are focusing even more on process automation than ever before. Drones, robots, autonomous vehicles are contributing in the businesses and we have seen numerous cases where drones were used for goods delivery, robots were used to tighten the social lock down in streets etc. Software based Robotic Process Automation is emerging now on a rapid pace and companies like Microsoft has already been   investing   a lot in Robotic ...
0 comments
Be the first person to recommend this.
Hi folks! In the last few days we have observed several news about the Coronavirus that started in China and around the world today is globalized in several regions of the world! My concern is to understand the seriousness of this moment and nothing better than numbers to reach the conclusion that the situation is critical! See my dashboard, I would be grateful for your comment or suggestion for improvement! Link to report: https://app.powerbi.com/view?r=eyJrIjoiNDRhNjQwNjQtZjRlNC00NDEzLTljMGEtMGUxNDRhZTJiNzY2IiwidCI6ImRkYzM1ZDUzLTgxMzUtNDYyNy1hYzM3LWIwZjAwNjQwNGI3MSJ9 Thanks! Vithor da Silva e Silva | Power BI UG Leader - Vitória-ES / Brazil Blog:  ...
0 comments