

You can import data from these sources into Power BI. Other data sources like Spark, websites, and Microsoft Exchange.Simple files in Excel, JSON, and other formats.Databases like SQL Server, Access, and Amazon Redshift.Online services like Salesforce and Dynamics 365.Power BI connects to a large number of varied data sources, such as: You can also download the PDF DirectQuery in SQL Server 2016 Analysis Services. This article primarily covers DirectQuery with Power BI, not SQL Server Analysis Services.įor more information about using DirectQuery with SQL Server Analysis Services, see Use DirectQuery for Power BI datasets and Analysis Services (preview). That feature shares many details with Direct Query in Power BI, but there are also important differences. DirectQuery is also a feature of SQL Server Analysis Services.
