In PowerApps, once you get beyond the basics of customizing SharePoint list forms, or just using the out-of-box form control in your apps, the next common thing that people like to do, is add some log…
Use of React and Office UI Fabric React in the PowerApps component framework is now available for pu…
<p>Today we have released support for one of our most popular feedback requests into public preview, allowing PowerApps component framework developers the ability to use React to build their com…
MBAS 2019 On-Demand Featured Sessions: Power BI Roadmap and Vision
The Microsoft Business Application Summit is behind us but that doesn’t mean there’s a lot of content we can share with the community. We recorded almost every session on site, and we made th…
2019 Microsoft Business Application Summit Retrospective
The Microsoft Busines Application Summit (MBAS) for 2019 was quite the event. There was so much great content. Check out our highlights from this year.
Today we’re announcing AI Builder, our low code artificial intelligence platform that supports the Power Platform. It will be available for consumption on data that already exists in the Common Data Service (CDS), the enterprise-grade datastore included in the Power Platform. AI Builder is the platform on which all our Dynamics 365 AI services are/will be built and customized, in addition to providing a low-code user experience for every developer to create and customize their PowerApps and Flows.
Introducing PowerApps Portals: powerful low-code websites for external users
Today we’re excited to announce “PowerApps Portals” which allows organizations to build powerful low-code websites which allow external users to interact with the data stored in Common Data Service. With the introduction of PowerApps Portals, we are also merging the capabilities offered by Dynamics 365 Customer Engagement portals to ensure that all the Dynamics 365 Customer Engagement application portals gets the benefit of our simplified low code offering.
Preview Instant Flow steps in Business Process Flows
With this preview, users can now run an instant flow to automate repetitive tasks, generate documents, track approvals, and more – on-demand from a step in a business process flow.
Hybrid Power BI session at Business Applications Summit 2019
Thanks for attending my Hybrid Power BI session at the #MSBizAppsSummit 2019 in Atlanta. Thanks for getting there so early in the morning (8:15) and for your valuable questions and feedback! As I p…
Slowly Changing Dimension SCD Power BI Lookup table data warehouse
Your Power BI model is fed by a data warehouse, and you'd like to make some reports, but now your Customer table has several entries for each customer instead of one. Then, you filter out the obsolete versions of customers, and you find that you're missing transactional data and you can't get Lifetime to Date (LTD)…
PowerQuery.com and my recorded sessions at MBAS 2019
The Microsoft Business Application Summit was a blast. If you missed it, you can now watch all the Power BI session recordings here, or get a great snapshot for the major new features on the FourMoo blog. What did you love the most? For me, it was the release of PowerQuery.com and the amazing focus …
Power BI dataflows and CDM Sessions from MBAS 2019
Last week Microsoft held its annual Microsoft Business Applications Summit (MBAS) event in Atlanta. This two-day technical conference covers the whole Business Applications platform – includi…
As a Power BI admin, particularly when you’re responsible for a large deployment with many teams using the Power BI service in different ways, you want to put yourself in a position to easily…
Detailed Article On The Power Query Formula Firewall And Data Privacy Settings
While writing my Microsoft Business Applications Summit session on Power Query-related reasons for Power BI dataset refresh failures (which you can watch online here for free, along with all the other…
An interesting challenge today come up while mentoring finance users in Power BI. Consider the following Excel layout. The user wants to unpivot the data by rotating the three header rows (Scenario Ty…
Level: Intermediate I was delivering some training last week for a customer in Sydney and they participants had an interesting problem where they needed to be able to report on a rolling time windo…
Paginated Report Bear And The Future Of Analysis Services Multidimensional
“Who, or what, is Paginated Report Bear?” I hear you ask. Well, he’s the breakout social media star of 2019, a furry YouTube sensation whose incisive interviews of members of the Power BI developme…
Think inside the box - Custom visuals using Standard Visuals
The context Looking at the evolution of Power BI during the last three and a half years, one thing that really is visible is the quantity of custom visuals and the variety of solutions that they let us solve. There is from simple table formatting options to advance analytics with forecasting neural ...
Why You Should Create Reports in Power BI Desktop Instead of the Power BI Service
This post is to make you aware that there are some serious downsides when you choose to create reports in the Power BI Service rather than Power BI Desktop. If you agree with me on this one, please vote for this idea here on the Power BI Ideas site . The Short Version of the Story I always recom
The June 2019 update of Power BI includes the ability to filter slicer items based on a measure. This article explains why this is an important feature that
Introduction to Charticulator: Create Custom Visual – Part 1
In the last post different ways of creating custom, visuals have been explained. In this post, I will show how to use Charticulator for creating a custom visual in Power BI. As mentioned, first navigate to the below link: Next, you need to click on the Launch Charticulator. This will navigate you to the main…
Budget vs Actual: Zero Complexity Model in Power BI
When I explain the Star Schema and best practices of data modeling in Power BI, Often I get questions such as what if we want to have budget and actuals in the same data model? what if there are two tables with different granularity? We cannot solve it with simple data modeling and relationships, this…
Announcing Paginated Reports in Power BI general availability
Based on the technology used in SQL Server Reporting Services, Paginated Reports brings a new set of enterprise reporting capabilities to the Power BI service. It enables developers and BI professionals to create and distribute highly formatted, pixel-perfect reports right alongside their interactive Power BI content, becoming the first cloud BI solution that combines the power of self-service BI with the needs and capabilities of traditional Enterprise BI scenarios.
Announcing AI Premium Workload, Cognitive Services and Azure ML general availability
Today, we’re announcing general availability (GA) for cognitive services, Azure ML and the AI workload in Power BI Premium. The AI workload will now be enabled by default for all P-nodes, as well as nodes A3/EM3 and above, allowing the users of those capacities to use cognitive services in dataflows right away. A new workload setting is added to separately enable Automated ML, which remains in public preview.