IntegrationPower BI/5 tutorials

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

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.