Microsoft Power BI
Microsoft Business Solutions16 Tammi 2022

Microsoft Power BI

While working with Power BI I primary faced two types of languages or scripts they are Power Query and DAX. Power query is very powerful in transforming the source data before they load into the reports or the user interface. Power query uses the M functions to write the data transformation codes. That is why they are also called M queries. If required we can use the R and Python scripts here while transforming data in Power BI. Once the data is transformed, the real-time measures and other data processing can be done using the DAX language. The full form of DAX is Data Analysis Expression. This is used once the data is processed using a Power query. This is available on the front end of power BI. But this is optional, DAX is needed only when we need to add any data processing logic in the report once the data is loaded. So in summary I find that the Power query or M query is for the backend data processing and DAX is for the front end data processing in Power BI.

There are many such observations around Microsoft Power BI that I am trying to share in this episode.

Jaksot(12)

Templating language for Power Apps Portal

Templating language for Power Apps Portal

Just an idea what is liquid and how to customise the power apps portal better.

25 Helmi 20221min

Automation features in D365 CRM

Automation features in D365 CRM

Automation is one of my favorite topics, so what options or features are there in Microsoft Dynamics 365 CRM let's have a look at them. Let's discuss the types of Processes in Dynamics 365 which are t...

20 Helmi 20224min

D365 CRM Entity Relationships

D365 CRM Entity Relationships

How can you predict the behavior of the effect of record deletion on its related records? If you are aware of the "Type of behavior" of the relationship between two entities in Microsoft Dynamics 365 ...

14 Helmi 20222min

Dynamics 365 ERP

Dynamics 365 ERP

Dynamics 365 (or D365) is an Enterprise Resource Planning (ERP). I can remember D365 used to be known as a CRM solution from Microsoft. However, with the progress of the solution, upcoming additions o...

2 Helmi 20221min

Extensibility of Dynamics 365

Extensibility of Dynamics 365

Recently we have integrated Dynamics 365 (or D365) with Leadfeeder. This has increased the efficiency of generating new quality leads and tracking the existing leads. The process is very simple and ea...

2 Helmi 20221min

Integrating Dynamics 365 with SharePoint

Integrating Dynamics 365 with SharePoint

Microsoft Dynamics 365 (in short D365) database cost is very high compared to other cloud storage like OneDrive or SharePoint. To save this cost and collaborate on the documents better in D365 it is r...

26 Tammi 20222min

Charts and Dashboards in Dynamics 365

Charts and Dashboards in Dynamics 365

Hi Friends, have you seen the charts and dashboards in Microsoft Dynamics 365? What do you think – how many charts and dashboards do you need to fulfil your reporting and data analytics needs? If you ...

19 Huhti 20211min