Power BI gateway data integration tutorials
Tutorials for refreshing Power BI reports on a schedule from live sources through the on-premises data gateway and CData Power BI connectors.
What this integration does
Reports built in Power BI Desktop can be published to PowerBI.com, the cloud service. To refresh them on a schedule from sources that sit inside your network, Power BI uses an on-premises data gateway that runs on a machine you control. The gateway makes the connection on the service's behalf each time a refresh runs.
How CData fits in
The CData Power BI Connector installs a DSN for the source, and Power BI uses that DSN to request a connection. For scheduled refresh the same DSN has to exist on the gateway machine, with credentials that work there. The tutorials cover setup, why refreshes fail, which accounts need which access, and how to schedule refreshes sensibly.
Power BI gateway tutorials by data source
Active DirectoryActive Directory in Power BI: Gateway and Refresh Questions
Answers to common questions about reporting on Active Directory users in Power BI with the CData Power BI Connector and refreshing the report through a gateway.
DatabricksSchedule a Databricks Power BI Refresh Through a Gateway
Set up a scheduled Databricks refresh in PowerBI.com with the CData Power BI Connector, and see what depends on the token, the cluster and the gateway machine.
Microsoft DataverseDataverse in Power BI Service: A Gateway Refresh Checklist
What to gather from your Power Platform and gateway admins, then how to publish a Dataverse report and schedule its refresh with the CData Power BI Connector.
SAPPutting SAP Data on a Power BI Gateway: A Security Review
Where the SAP libraries, credentials and DSN live when the CData Power BI Connector feeds PowerBI.com through a gateway, and what your security team should review.
SharePointSharePoint Dataset Won't Refresh in Power BI? Gateway Fixes
Work through why a SharePoint dataset built on the CData Power BI Connector refreshes in Desktop but fails in PowerBI.com, from DSN bitness to gateway settings.
Don't see your data source or tool?
CData connects hundreds of sources to the tools you already use. Browse the connectors, or talk to us about a specific setup.