Datakilder i Power BI DesktopData sources in Power BI Desktop

Med Power BI Desktop kan du oprette forbindelse til data fra mange forskellige kilder.With Power BI Desktop, you can connect to data from many different sources. Du finder en komplet liste over tilgængelige datakilder i Power BI-datakilder.For a full list of available data sources, see Power BI data sources.

Du opretter forbindelse til data ved hjælp af båndet Hjem.You connect to data by using the Home ribbon. Hvis du vil have vist menuen med de mest almindelige datatyper, skal du vælge knappen Hent data eller pil ned.To show the Most Common data types menu, select the Get Data button label or the down arrow.

Menuen med de mest almindelige datatyper, Hent data i Power BI Desktop

Hvis du vil gå til dialogboksen Hent data, skal du åbne menuen med de mest almindelige datatyper og vælge Mere.To go to the Get Data dialog box, show the Most Common data types menu and select More. Du kan også åbne dialogboksen Hent data (og omgå menuen Mest almindelige) ved at vælge ikonet Hent data direkte.You can also bring up the Get Data dialog box (and bypass the Most Common menu) by selecting the Get Data icon directly.

Knappen Hent data i Power BI Desktop

Bemærk

Power BI-teamet udvider hele tiden de datakilder, der er tilgængelige for Power BI Desktop og Power BI-tjenesten.The Power BI team is continually expanding the data sources available to Power BI Desktop and the Power BI service. Du kan derfor ofte se tidlige versioner af igangværende datakilder markeret som Beta eller Preview.As such, you'll often see early versions of work-in-progress data sources marked as Beta or Preview. Alle datakilder, der er markeret som beta eller prøveversion, har begrænset support og funktionalitet og bør ikke bruges i produktionsmiljøer.Any data source marked as Beta or Preview has limited support and functionality, and it shouldn't be used in production environments. Derudover er alle data, der er markeret som beta eller prøveversion for Power BI Desktop, muligvis ikke tilgængelige til brug i Power BI-tjenesten eller andre Microsoft-tjenester, før datakilden bliver generelt tilgængelig.Additionally, any data source marked as Beta or Preview for Power BI Desktop may not be available for use in the Power BI service or other Microsoft services until the data source becomes generally available (GA).

Bemærk

Der er mange dataconnectors til Power BI Desktop, der kræver Internet Explorer 10 (eller nyere) til godkendelse.There are many data connectors for Power BI Desktop that require Internet Explorer 10 (or newer) for authentication.

DatakilderData sources

Dialogboksen Hent data organiserer datatyper i følgende kategorier:The Get Data dialog box organizes data types in the following categories:

  • AlleAll
  • FilFile
  • DatabaseDatabase
  • Power PlatformPower Platform
  • AzureAzure
  • OnlinetjenesterOnline Services
  • AndetOther

Kategorien Alle inkluderer alle dataforbindelsestyper fra alle kategorier.The All category includes all data connection types from all categories.

FildatakilderFile data sources

Kategorien Fil indeholder følgende dataforbindelser:The File category provides the following data connections:

  • ExcelExcel
  • Tekst/CSVText/CSV
  • XMLXML
  • JSONJSON
  • MappeFolder
  • PDFPDF
  • SharePoint-mappeSharePoint folder

På følgende billede vises vinduet Hent data for Fil.The following image shows the Get Data window for File.

Fildatakilder, dialogboksen Hent data, Power BI Desktop

DatabasedatakilderDatabase data sources

Kategorien Database indeholder følgende dataforbindelser:The Database category provides the following data connections:

  • SQL Server-databaseSQL Server database
  • Access-databaseAccess database
  • SQL Server Analysis Services-databaseSQL Server Analysis Services database
  • Oracle-databaseOracle database
  • IBM DB2-databaseIBM DB2 database
  • IBM Informix-database (beta)IBM Informix database (Beta)
  • IBM NetezzaIBM Netezza
  • MySQL-databaseMySQL database
  • PostgreSQL-databasePostgreSQL database
  • Sybase-databaseSybase database
  • Teradata-databaseTeradata database
  • SAP HANA-databaseSAP HANA database
  • SAP Business Warehouse-programserverSAP Business Warehouse Application Server
  • SAP Business Warehouse-meddelelsesserverSAP Business Warehouse Message Server
  • Amazon RedshiftAmazon Redshift
  • ImpalaImpala
  • Google BigQueryGoogle BigQuery
  • VerticaVertica
  • SnowflakeSnowflake
  • EssbaseEssbase
  • AtScale-kuberAtScale cubes
  • BI ConnectorBI Connector
  • Data Virtuality LDW (beta)Data Virtuality LDW (Beta)
  • DenodoDenodo
  • DremioDremio
  • ExasolExasol
  • Indexima (beta)Indexima (Beta)
  • InterSystems IRIS (beta)InterSystems IRIS (Beta)
  • Jethro (beta)Jethro (Beta)
  • KyligenceKyligence
  • MarkLogicMarkLogic

Bemærk

Nogle databaseforbindelser kræver, at du aktiverer dem ved at vælge Filer > Indstillinger > Indstillinger og derefter vælger Funktioner til eksempelvisning og aktiverer forbindelsen.Some database connectors require that you enable them by selecting File > Options and settings > Options then selecting Preview Features and enabling the connector. Hvis du ikke kan se nogle af de forbindelser, der er nævnt ovenfor, og du vil bruge dem, skal du kontrollere dine indstillinger for Funktioner til eksempelvisning.If you don't see some of the connectors mentioned above and want to use them, check your Preview Features settings. Bemærk også, at alle datakilder, der er markeret som Beta eller Preview, har begrænset support og funktionalitet og skal ikke bruges i produktionsmiljøer.Also note that any data source marked as Beta or Preview has limited support and functionality, and should not be used in production environments.

På følgende billede vises vinduet Hent data for Database.The following image shows the Get Data window for Database.

Databasedatakilder, dialogboksen Hent data, Power BI Desktop

Power Platform-datakilderPower Platform data sources

Kategorien Power Platform indeholder følgende dataforbindelser:The Power Platform category provides the following data connections:

  • Power BI-datasætPower BI datasets
  • Power BI-dataflowPower BI dataflows
  • Common Data ServiceCommon Data Service
  • Dataflow til Power PlatformPower Platform dataflows

På følgende billede vises vinduet Hent data for Power Platform.The following image shows the Get Data window for Power Platform.

Power Platform-datakilder, dialogboksen Hent data, Power BI Desktop

Azure-datakilderAzure data sources

Kategorien Azure indeholder følgende dataforbindelser:The Azure category provides the following data connections:

  • Azure SQL DatabaseAzure SQL Database
  • Azure SQL Data WarehouseAzure SQL Data Warehouse
  • Azure Analysis Services-databaseAzure Analysis Services database
  • Azure Database for PostgreSQLAzure Database for PostgreSQL
  • Azure Blob StorageAzure Blob Storage
  • Azure Table StorageAzure Table Storage
  • Azure Cosmos DBAzure Cosmos DB
  • Azure Data Lake Storage Gen2Azure Data Lake Storage Gen2
  • Azure Data Lake Storage Gen1Azure Data Lake Storage Gen1
  • Azure HDInsight (HDFS)Azure HDInsight (HDFS)
  • Azure HDInsight SparkAzure HDInsight Spark
  • Interaktiv HDInsight-forespørgselHDInsight Interactive Query
  • Azure Data Explorer (Kusto)Azure Data Explorer (Kusto)
  • Azure Cost ManagementAzure Cost Management

På følgende billede vises vinduet Hent data for Azure.The following image shows the Get Data window for Azure.

Azure-datakilder, dialogboksen Hent data, Power BI Desktop

Online Services-datakilderOnline Services data sources

Kategorien Onlinetjenester indeholder følgende dataforbindelser:The Online Services category provides the following data connections:

  • SharePoint Online-listeSharePoint Online List
  • Microsoft Exchange OnlineMicrosoft Exchange Online
  • Dynamics 365 (online)Dynamics 365 (online)
  • Dynamics NAVDynamics NAV
  • Dynamics 365 Business CentralDynamics 365 Business Central
  • Dynamics 365 Business Central (i det lokale miljø)Dynamics 365 Business Central (on-premises)
  • Microsoft Azure Consumption Insights (beta)Microsoft Azure Consumption Insights (Beta)
  • Azure DevOps (kun forummer)Azure DevOps (Boards only)
  • Azure DevOps Server (kun forummer)Azure DevOps Server (Boards only)
  • Salesforce-objekterSalesforce Objects
  • Salesforce-rapporterSalesforce Reports
  • Google AnalyticsGoogle Analytics
  • Adobe AnalyticsAdobe Analytics
  • appFigures (beta)appFigures (Beta)
  • Data.World – Get Dataset (beta)Data.World - Get Dataset (Beta)
  • GitHub (beta)GitHub (Beta)
  • LinkedIn Sales Navigator (beta)LinkedIn Sales Navigator (Beta)
  • Marketo (beta)Marketo (Beta)
  • Mixpanel (beta)Mixpanel (Beta)
  • Planview Enterprise One – PRM (beta)Planview Enterprise One - PRM (Beta)
  • Planview Projectplace (beta)Planview Projectplace (Beta)
  • QuickBooks Online (beta)QuickBooks Online (Beta)
  • SmartsheetSmartsheet
  • SparkPost (beta)SparkPost (Beta)
  • SweetIQ (beta)SweetIQ (Beta)
  • Planview Enterprise One – CTM (beta)Planview Enterprise One - CTM (Beta)
  • Twilio (beta)Twilio (Beta)
  • tyGraph (beta)tyGraph (Beta)
  • Webtrends (beta)Webtrends (Beta)
  • Zendesk (beta)Zendesk (Beta)
  • Asana (beta)Asana (Beta)
  • Dynamics 365 Customer Insights (beta)Dynamics 365 Customer Insights (Beta)
  • Emigo-datakildeEmigo Data Source
  • Entersoft Business Suite (beta)Entersoft Business Suite (Beta)
  • FactSet Analytics (beta)FactSet Analytics (Beta)
  • Industrial App StoreIndustrial App Store
  • Intune Data Warehouse (beta)Intune Data Warehouse (Beta)
  • Microsoft Graph Security (beta)Microsoft Graph Security (Beta)
  • Product Insights (beta)Product Insights (Beta)
  • Quick BaseQuick Base
  • TeamDesk (beta)TeamDesk (Beta)
  • Workplace Analytics (beta)Workplace Analytics (Beta)
  • Projectplace til Power BI (beta)Projectplace for Power BI (Beta)
  • Webtrends Analytics (beta)Webtrends Analytics (Beta)
  • Zoho Creator (beta)Zoho Creator (Beta)

På følgende billede vises vinduet Hent data for Onlinetjenester.The following image shows the Get Data window for Online Services.

Online Services-datakilder, dialogboksen Hent data, Power BI Desktop

Andre datakilderOther data sources

Kategorien Andet indeholder følgende dataforbindelser:The Other category provides the following data connections:

  • WebWeb
  • SharePoint-listeSharePoint list
  • OData-feedOData Feed
  • Active DirectoryActive Directory
  • Microsoft ExchangeMicrosoft Exchange
  • Hadoop-fil (HDFS)Hadoop File (HDFS)
  • SparkSpark
  • Hive LLAP (beta)Hive LLAP (Beta)
  • R-scriptR script
  • Python-scriptPython script
  • ODBCODBC
  • OLE DBOLE DB
  • BI360 – Budgeting & Financial Reporting (beta)BI360 - Budgeting & Financial Reporting (Beta)
  • Cognite Data Fusion (beta)Cognite Data Fusion (Beta)
  • FHIRFHIR
  • Information Grid (beta)Information Grid (Beta)
  • Jamf Pro (beta)Jamf Pro (Beta)
  • MicroStrategy for Power BIMicroStrategy for Power BI
  • PaxatasPaxata
  • QubolePresto (beta)QubolePresto (Beta)
  • Roamler (beta)Roamler (Beta)
  • SiteimproveSiteimprove
  • SurveyMonkey (beta)SurveyMonkey (Beta)
  • TIBCO(R) Data Virtualization (beta)TIBCO(R) Data Virtualization (Beta)
  • Vena (beta)Vena (Beta)
  • Workforce Dimensions (beta)Workforce Dimensions (Beta)
  • Zucchetti HR Infinity (beta)Zucchetti HR Infinity (Beta)
  • Tenforce (Smart)ListTenforce (Smart)List
  • Shortcuts Business Insights (beta)Shortcuts Business Insights (Beta)
  • Vessel Insight (beta)Vessel Insight (Beta)
  • Tom forespørgselBlank Query

På følgende billede vises vinduet Hent data for Andet.The following image shows the Get Data window for Other.

Andre datakilder, dialogboksen Hent data, Power BI Desktop

Bemærk

På nuværende tidspunkt er det ikke muligt at oprette forbindelse til brugerdefinerede datakilder, der er beskyttet via Azure Active Directory.At this time, it's not possible to connect to custom data sources secured using Azure Active Directory.

Oprettelse af forbindelse til en datakildeConnecting to a data source

For at oprette forbindelse til en datakilde skal du vælge datakilden i vinduet Hent data og vælge Opret forbindelse.To connect to a data source, select the data source from the Get Data window and select Connect. På følgende billede er Web valgt fra kategorien Andet for dataforbindelsen.In the following image, Web is selected from the Other data connection category.

Opret forbindelse til internettet, dialogboksen Hent data, Power BI Desktop

Der vises et forbindelsesvindue, som er specifikt for typen af dataforbindelse.A connection window is displayed, specific to the type of data connection. Hvis der kræves legitimationsoplysninger, bliver du bedt om at angive dem.If credentials are required, you’ll be prompted to provide them. På følgende billede vises en URL-adresse, der angives for at oprette forbindelse til en webdatakilde.The following image shows a URL being entered to connect to a Web data source.

Input-URL, dialogboksen Fra web, Power BI Desktop

Indtast forbindelsesoplysninger for URL-adressen eller ressourcen, og vælg OK.Enter the URL or resource connection information, and then select OK. Power BI Desktop opretter forbindelse til datakilden og viser de tilgængelige datakilder i Navigator.Power BI Desktop makes the connection to the data source, and it presents the available data sources in the Navigator.

Dialogboksen Navigator i Power BI Desktop

Du indlæser dataene ved at vælge knappen Indlæs nederst i ruden Navigator.To load the data, select the Load button at the bottom of the Navigator pane. Hvis du vil transformere eller redigere forespørgslen i Power Query-editor, før du indlæser dataene, skal du vælge knappen Transformér data.To transform or edit the query in Power Query Editor before loading the data, select the Transform Data button.

Det er det eneste, du skal gøre for at oprette forbindelse til datakilder i Power BI Desktop!That’s all there is to connecting to data sources in Power BI Desktop! Prøv at oprette forbindelse til data fra vores stadig større liste over datakilder, og vend ofte tilbage – vi tilføjer hele tiden nye datakilder på denne liste.Try connecting to data from our growing list of data sources, and check back often - we continue to add to this list all the time.

Brug af PBIDS-filer til at hente dataUsing PBIDS files to get data

PBIDS-filer er Power BI Desktop-filer, der har en bestemt struktur, og som har filtypenavnet PBIDS, der identificerer, at der er tale om en Power BI-datakildefil.PBIDS files are Power BI Desktop files that have a specific structure, and they have a .PBIDS extension to identify it is a Power BI data source file.

Du kan oprette en PBIDS-fil for at strømline Hent data for forfattere af rapporter i din organisation.You can create a PBIDS file to streamline the Get Data experience for report creators in your organization. Vi anbefaler, at en administrator opretter disse filer til almindeligt anvendte forbindelser for at gøre det nemmere for en ny rapportforfatter at bruge PBIDS-filer.To make it easier for a new report author to use PBIDS files, we recommend that an administrator create these files for commonly used connections.

Når en forfatter åbner en PBIDS-fil, åbnes Power BI Desktop, og brugeren bliver bedt om at angive legitimationsoplysninger for at godkende og oprette forbindelse til den datakilde, der er angivet i filen.When an author opens a PBIDS file, Power BI Desktop opens and prompts the user for credentials to authenticate and connect to the data source that's specified in the file. Dialogboksen Navigation vises, og brugeren skal vælge de tabeller i datakilden, der skal indlæses i modellen.The Navigation dialog box appears, and the user must select the tables from that data source to load into the model. Brugerne skal muligvis også vælge databasen eller databaserne, hvis der ikke blev angivet en i PBIDS-filen.Users may also need to select the database(s) if none was specified in the PBIDS file.

Fremover kan brugeren begynde at oprette visualiseringer eller vælge Seneste kilder igen for at indlæse et nyt sæt tabeller i modellen.From that point forward, the user can begin building visualizations or select Recent Sources to load a new set of tables into the model.

I øjeblikket understøtter PBIDS-filer kun en enkelt datakilde i én fil.Currently, PBIDS files only support a single data source in one file. Hvis du angiver mere end én datakilde, resulterer det i en fejl.Specifying more than one data source results in an error.

Hvis du vil oprette PBIDS-filen, skal en administrator angive de påkrævede input for en enkelt forbindelse.To create the PBIDS file, an administrator must specify the required inputs for a single connection. De kan også angive forbindelsestilstanden som enten DirectQuery eller Import.They can also specify the connection mode as either DirectQuery or Import. Hvis tilstand mangler/er null i filen, bliver den bruger, der åbner filen i Power BI Desktop, bedt om at vælge DirectQuery eller Import.If mode is missing/null in the file, the user who opens the file in Power BI Desktop is prompted to select DirectQuery or Import.

Eksempler på PBIDS-filerPBIDS file examples

Dette afsnit indeholder nogle eksempler på datakilder, der ofte bruges.This section provides some examples from commonly used data sources. PBIDS-filtypen understøtter kun dataforbindelser, der også understøttes i Power BI Desktop, med to undtagelser: Live Connect og Tom forespørgsel.The PBIDS file type only supports data connections that are also supported in Power BI Desktop, with two exceptions: Live Connect and Blank Query.

PBIDS-filen indeholder ikke oplysninger om godkendelse og tabel- og skemaoplysninger.The PBIDS file doesn't include authentication information and table and schema information.

Følgende kodestykke viser almindelige eksempler på PBIDS-filer, men listen er ikke fuldstændig.The following code snippets show several common examples for PBIDS files, but they aren't complete or comprehensive. I forbindelse med andre datakilder kan du se DSR-formatet (Data Source Reference) for protokol- og adresseoplysninger.For other data sources, you can refer to the Data Source Reference (DSR) format for protocol and address information.

Disse eksempler er kun ment som en hjælp og er ikke en udtømmende liste. De omfatter heller ikke alle understøttede connectorer i DSR-format.These examples are for convenience only, aren't meant to be comprehensive, and don't include all supported connectors in DSR format. Administratorer eller organisationer kan oprette deres egne datakilder ved hjælp af disse eksempler som vejledninger og benytte dem til at oprette og understøtte deres egne datakildefiler.An administrator or organization can create their own data sources using these examples as guides, from which they can create and support their own data source files.

Azure ASAzure AS

{ 
    "version": "0.1", 
    "connections": [ 
    { 
        "details": { 
        "protocol": "analysis-services", 
        "address": { 
            "server": "server-here" 
        }, 
        } 
    } 
    ] 
}

MappeFolder

{ 
  "version": "0.1", 
  "connections": [ 
    { 
      "details": { 
        "protocol": "folder", 
        "address": { 
            "path": "folder-path-here" 
        } 
      } 
    } 
  ] 
} 

ODataOData

{ 
  "version": "0.1", 
  "connections": [ 
    { 
      "details": { 
        "protocol": "odata", 
        "address": { 
            "url": "URL-here" 
        } 
      } 
    } 
  ] 
} 

SAP BWSAP BW

{ 
  "version": "0.1", 
  "connections": [ 
    { 
      "details": { 
        "protocol": "sap-bw-olap", 
        "address": { 
          "server": "server-name-here", 
          "systemNumber": "system-number-here", 
          "clientId": "client-id-here" 
        }, 
      } 
    } 
  ] 
} 

SAP HanaSAP Hana

{ 
  "version": "0.1", 
  "connections": [ 
    { 
      "details": { 
        "protocol": "sap-hana-sql", 
        "address": { 
          "server": "server-name-here:port-here" 
        }, 
      } 
    } 
  ] 
} 

SharePoint-listeSharePoint list

URL-adressen skal pege på selve SharePoint-webstedet og ikke en liste på webstedet.The URL must point to the SharePoint site itself, not to a list within the site. Brugerne får en navigator, der giver dem mulighed for at vælge en eller flere lister fra det pågældende websted, som hver især bliver en tabel i modellen.Users get a navigator that allows them to select one or more lists from that site, each of which becomes a table in the model.

{ 
  "version": "0.1", 
  "connections": [ 
    { 
      "details": { 
        "protocol": "sharepoint-list", 
        "address": { 
          "url": "URL-here" 
        }, 
       } 
    } 
  ] 
} 

SQL ServerSQL Server

{ 
  "version": "0.1", 
  "connections": [ 
    { 
      "details": { 
        "protocol": "tds", 
        "address": { 
          "server": "server-name-here", 
          "database": "db-name-here (optional) "
        } 
      }, 
      "options": {}, 
      "mode": "DirectQuery" 
    } 
  ] 
} 

TekstfilText file

{ 
  "version": "0.1", 
  "connections": [ 
    { 
      "details": { 
        "protocol": "file", 
        "address": { 
            "path": "path-here" 
        } 
      } 
    } 
  ] 
} 

WebWeb

{ 
  "version": "0.1", 
  "connections": [ 
    { 
      "details": { 
        "protocol": "http", 
        "address": { 
            "url": "URL-here" 
        } 
      } 
    } 
  ] 
} 

DataflowDataflow

{
  "version": "0.1",
  "connections": [
    {
      "details": {
        "protocol": "powerbi-dataflows",
        "address": {
          "workspace":"workspace id (Guid)",
          "dataflow":"optional dataflow id (Guid)",
          "entity":"optional entity name"
        }
       }
    }
  ]
}

Næste trinNext steps

Du kan gøre mange forskellige ting med Power BI Desktop.You can do all sorts of things with Power BI Desktop. Du kan finde flere oplysninger om funktionerne i følgende ressourcer:For more information on its capabilities, check out the following resources: