Changes and Updates to Azure Services – Microsoft AZ-900 Exam
18.6. Changes and Updates to Azure Services The cloud computing landscape is dynamic, with continuous innovation and rapid deployment of new features and services being the norm. Microsoft Azure, as one of the leading cloud platforms, frequently updates its services to address the ever-evolving needs of its users, adapt to technological advancements, and enhance security, […]
Exploring query types – Connecting to Data Sources
Exploring query types When Power BI connects to any data source, it makes one of two types of connections or queries. DirectQuery The first type is called DirectQuery, or a live connection to the data. This means that Power BI is storing credentials and a connection string to the data source. For example, this could […]
Power BI datasets – Connecting to Data Sources
Power BI datasets Data used in Power BI reports uses a Power BI dataset. Power BI datasets are basically a connection string and credentials that Power BI uses to connect to a data source. Every report that is created in Power BI must have a dataset associated with it. This ensures the report has data […]
Query performance tuning – Connecting to Data Sources
Query performance tuning When considering optimizing the performance of Power BI queries, there are a few places to start, and the recommendation is to look at each as a layer of performance tuning to undertake. These layers include reducing the size of the data, optimizing DirectQuery (when used), and optimizing composite models (when used). Reducing […]
Power BI as a solution – Overview of Power BI and the PL-300 Exam
Power BI as a solution Power BI has two main versions: Power BI Desktop and the Power BI service. Power BI Desktop Power BI Desktop is a visual data exploration and interactive reporting tool, providing a free-form canvas for drag-and-drop exploration of your data, an extensive library of interactive visualizations, and an authoring experience for […]
DirectQuery optimization – Connecting to Data Sources
DirectQuery optimization When using DirectQuery, it’s important to remember that the total performance experienced is dependent upon both Power BI and the underlying data source. Many times, Power BI reports will use a data warehouse such as Azure Synapse Analytics as the data source and for enterprise data warehouses like this, there are several considerations […]
Composite model optimization – Connecting to Data Sources
Composite model optimization When something is composite, it is made up of more than one thing. Composite models in Power BI mean that a single data model contains data from multiple sources, and these can be both Import and DirectQuery. Note that composite models can’t be used for every data source type, and they introduce […]
Advanced options (what-if parameters, Power Query parameters, PBIDS files, and XMLA endpoints) – Connecting to Data Sources
Advanced options (what-if parameters, Power Query parameters, PBIDS files, and XMLA endpoints) Power BI provides many advanced capacities. From tools for creating what-if analysis to dynamic DAX code, to storing data sources and structures for ease of use to serving advanced connections, to a myriad of data consumers using XML for Analysis (XMLA), including other […]
Creating Azure AD AUs – Microsoft AZ-104 Exam
Creating Azure AD AUs Azure AD AUs are used in scenarios where granular administrative control is required. AUs have the following prerequisites: Tip AUs can be created via the Azure portal or PowerShell. The easiest way to explain AUs is by using a scenario. A company called Contoso is a worldwide organization with users across […]
Changes and Updates to Azure Services 2 – Microsoft AZ-900 Exam
Major Updates and Service Additions in Azure Over the years, Azure has seen significant changes and additions. Below is a hypothetical but illustrative list of the types of updates Azure might introduce: Azure Kubernetes Service (AKS) Enhancements: Microsoft might roll out updates to AKS, offering new networking features, improved scalability, or integration with other Azure […]