- Identify and connect to a data source
- Get data from a relational database, such as Microsoft SQL Server
- Get data from a file, such as Microsoft Excel
- Get data from applications
- Get data from Azure Analysis Services
- Select a storage mode
- Fix performance issues
- Resolve data import errors
Get data from files
- import data
- Change the location of a source file during development:
- Data source setting
2. Transform data-> data source settings
Get data from a SQL database
Get data from a NoSQL database(Azure Cosmos DB)
A NoSQL database (also referred to as non-SQL, not only SQL or non-relational) is a flexible type of database that does not use tables to store data.
Connect to data in an application
url:
Connect to data in an application
https://docs.microsoft.com/en-us/learn/modules/get-data/5-online-services
Storage mode:
- Import
- DirectQuery
- Dual (Composite)
Azure Analysis Services
Similar to SQL server. But can build calculations.
- Analysis Services cubes have calculations already in the cube.
- You can query the data directly. Use multi-dimensional expressions (MDX) or data analysis expressions (DAX). ????????????
- In SQL Server(using Transact-SQL (T-SQL) to query the data).
Azure Analysis Services uses the tabular model and DAX to build calculations, similar to Power BI. These models are compatible with one another.
Using the Connect live option helps you keep the data and DAX calculations in their original location, without having to import them all into Power BI. Data is refreshed in the service, Power BI reports will immediately be updated, without the need to initiate a Power BI refresh schedule.
- You can import the data directly into Power BI.
- Or you can import data (from Excel, SQL Server…) into the Azure Analysis Services model and then use a live connection. Using this approach, the data modeling and DAX measures are all performed in one place, and it’s a much simpler way to maintain your solution.
https://docs.microsoft.com/en-us/learn/modules/get-data/8-performance-issues
