3.1 Power BI Connection

Load data from the Gateway into Power BI.

1. Get Data → OData Feed
2. URL: http://server:5000/odata/demo
3. OK
4. Select tables
5. Load or Transform

For large datasets:

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

For real-time data without import:

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