Database Reference
In-Depth Information
How it works...
Sharing, visualization,
Question and Answer
(
Q&A
), and accessibility flexibility for
Power BI are enabled with your subscription. No on-site (high-specification) infrastructure
investment is required to start consuming this Microsoft service. Uploading and providing
access to the reports is configured using SharePoint functions on the site. All of the pro-
cessing is handled by the Microsoft service. This will work if you have direct access to the
data source.
With Data Management Gateway, you can register on-premise data sources before enabling
OData feed or cloud access for the data sources. The Data Management Gateway service is
installed locally and responds to requests from the cloud service:
• When creating a data source, the credentials are encrypted with a certificate owned
by you and are stored in the credential store. The credential store can be configured
either within the gateway (on premise) or in the cloud service.
• To respond to data requests from the cloud service, the gateway decrypts the re-
quest with the certificate to get the credentials, and uses credentials to pull data
from the data source.
Data sources are configured in the Power BI admin center. Tables or views from a database
can be made available using OData feed access. Data is parsed through the gateway. Power
Query provider, for example, is bundled with Data Management Gateway to connect the
queries and execute Power Query to load data in the Excel sheet, as shown in the following
diagram:
