Author: admin
-
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…
