Inhaltsverzeichnis
Ist Power Bi eine Datenbank?
Auf der anderen Seite ist Power BI aber keine Datenbank, da es Daten nicht dauerhaft speichert, sondern sie nur temporär bis zur nächsten Aktualisierung aufbewahrt.
Wo speichert Power Bi Daten?
Power BI speichert Informationen, die globaler Natur sind, wie Benutzer-IDs und Profildaten, in einem Rechenzentrum in den USA. Alle Power BI-Kundendaten sowie die geografisch redundanten Spiegelungen und Offsite-Backups werden innerhalb des ausgewählten Raumes gespeichert.
Was ist DirectQuery?
DirectQuery ist auch ein Feature von SQL Server Analysis Services. Informationen zur Verwendung von DirectQuery mit SQL Server Analysis Services finden Sie unter DirectQuery in SQL Server 2016 Analysis Services.
What is the ODBC connector in Power BI Desktop?
The ODBC connector in Power BI Desktop lets you import data from any third-party ODBC driver simply by specifying a Data Source Name (DSN) or a connection string. As an option, you can also specify a SQL statement to execute against the ODBC driver.
What is Power BI Desktop Data Interface?
Power BI Desktop data interfaces Power BI Desktop includes an ever-growing collection of data connectors that are built to connect to a specific data source.
How do I import data from a third party ODBC driver?
Submit your idea to the Power BI team’s list of ideas and requests. The ODBC connector in Power BI Desktop lets you import data from any third-party ODBC driver simply by specifying a Data Source Name (DSN) or a connection string. As an option, you can also specify a SQL statement to execute against the ODBC driver.
In Power BI, click on Get Data -> All -> DataDirectODBC. Choose it and you should now see a form as shown below where it will ask for DSN name. Also under Data Connectivity mode -> Choose DirectQuery You should now see that DirectQuery has been enabled for querying DataDirect ODBC driver in Power BI footer as shown below