Power Apps:
Learn from Zero to Hero
I write about Power Platform, Power Apps, Power BI, Power Automate, Business Central, and Microsoft Fabric.
-
-
How to get a Collection from Power Automate Flow using ParseJSON function in Power Apps Canvas App
Triggering a Power Automate flow from a Power Canvas App and receiving the result back is a fantastic way to enhance your app’s functionality. Below, I’ve provided step-by-step instructions on how to trigger a Power Automate flow from a Power Canvas App and return a collection within the app. In this example, we’ll create a…
-
#10 Microsoft Fabric: Boost Your Power BI with Python Integration
Are you ready to supercharge your Power BI experience with Python scripting? Follow these steps to seamlessly integrate Python into Power BI and unlock powerful data analysis capabilities: Step 1: Update Power BI Desktop Always use the latest version for optimal performance. Avoid the AppStore and download directly from Microsoft’s official site: Step 2: Install…
-
Azure Data Factory: Configure Linked Service to Business Central using OAuth 2.0
1. Access to Data factories in Azure Portal 2. Create a New Data Factory Instance or use the existing one 3. Launch Azure Data Factory Studio 4. Under Manage > Linked Services > New > OData 5. Configuration for New linked service: 6. Snapshot for Configuration for New linked service 7. To Ingest data from…
-
DAX Query: Power up your Power BI!
Instead of using an external tool like Dax Studio, you can now write DAX queries and their interaction without leaving Power BI Desktop. This gives you a lot of advantages in building your semantic model. Several advantages that you can do: What stuff you can apply straight away? Here are some examples: Here is the…
-
Microsoft Fabric: Are you ready to employ an all-in-one analytics solution?
As I have a look, almost all the main features are ready now. Dataverse is now linked to Fabric using Synapse Link for Dataverse. It is quite ok as I have done some tests. Data Activator is also in Public Preview. As we can centralize data everywhere in MS Fabric and sync data across the…
-
How to configure to test Business Central APIs using Postman in one screen?
How to configure to test Business Central APIs using Postman in one screen? Check it below!
-
#8 Microsoft Fabric: Create SQL Query and view
We can manage our warehouse within our workspace by using SQL endpoint. In this test, we will write a SQL statement that calculates the total sales amount by month. We’ll then save this statement as a view in our SQL endpoint (Warehouse). This will allow us to easily access the total sales amount by month…
-
#7 Microsoft Fabric: Create & work with notebooks in LakeHouse
It’s amazing. We can easily create a Fabric Notebook within the LakeHouse. We do not need to do any jobs for configuration for Spark, Scala, or Python to run the script. What you need to do is just drag & drop, and then let Fabric automatically generate codes for us. Let’s try it now to…
-
Microsoft Fabric Licensing
A Microsoft Fabric subscription consists of tenants, capacities, and workspaces and can be organized in various ways according to your organizational needs. This illustration provides two example subscriptions, each organized differently. Typically, companies organize their subscription in a model that resembles the Retail company A example. Licensing includes: 1. Capacity unit cost 2. Storage Cost…
-
#6 Microsoft Fabric: Data model – create relationships in the Lakehouse
In this article, we’ll create a star schema that you might see from data warehouses: It resembles a star. The center of the star is a Fact table. The surrounding tables are called Dimension tables, which are related to the Fact table with relationships. Let’s get started! 1. In the workspace view, select the SQL…
-
#5 Microsoft Fabric: Create data Pipeline using Data Factory
The Pipeline in Microsoft Fabric comes from Azure Data Factory which allows us to execute a group of actions and combine them into a single workflow. For example, we may want to create the Pipeline to send out an email, copy data and save it somewhere, run a procedure, etc. In this article, we will…
-
#4 Microsoft Fabric: Prepare and load data into your LakeHouse
To prepare and load data into your lakehouse, take the following steps: 1. From your Power BI Workspace, select your Lakehouse to navigate to the Lakehouse editor 2. Once you’re in the Lakehouse editor, select New Dataflow Gen2. 83. Once you’re in the Power Query Online editor for Dataflows Gen2, select Import from a Power Query template and choose the…
-
#3 Microsoft Fabric: Create LakeHouse to store structure and unstructure data
To store structure and unstructure data from Power BI, you can create a LakeHouse by following the below steps. 1. Navigate to your Power BI > Workspaces > select New workspace > Configure your new workspace > then Apply. 2. Navigate to the new workspace to create a new Lakehouse 2.1. Select New > then…
-
#2 Microsoft Fabric: Configure to enable Microsoft Fabric
To enable Microsoft Fabric, follow steps below. You need Power BI Admin right (or Microsoft 365 Global admin, Power Platform admin). 1. Login to Microsoft Power BI with your Account and go to Power BI Admin Portal 2. Navigate to the tenant settings > Microsoft Fabric (Preview), and expand the Users can create Fabric items (public…
-
#1 Microsoft Fabric: all-in-one analytics solution
Microsoft Fabric has just been introduced at the Microsoft Build 2023. Let’s forget about using Power BI, Warehouse, and Azure Synapse separately. Now you can use Microsoft Fabric as all-in-one analytics solution that covers everything from Data Integration, Data Warehouse, to Data Science, Real-Time Analytics, and Business Intelligence. We can maintain and deliver the Data Analytics…
-
Join 900+ subscribers
Stay in the loop with everything you need to know about Power Apps.
