3.1 Power BI Connection

Load data from the Gateway into Power BI.

Power BI Desktop

  1. Get DataOData Feed
  2. OK
  3. Select tables
  4. Load or Transform

In Power Query

For large datasets:

  1. Choose Transform
  2. Keep only required columns
  3. Set filters
  4. Close and Apply

DirectQuery

For real-time data without import:

Power BI has limited DirectQuery support for OData. Recommendation: Import with scheduled refresh.

Zuletzt geändert: on 2026/01/29 at 11:23 PM