====== 3.1 Power BI Connection ======

Load data from the Gateway into Power BI.

===== Power BI Desktop =====

  - **Get Data** -> **OData Feed**
  - URL: ''http://server:5000/odata/demo''
  - **OK**
  - Select tables
  - **Load** or **Transform**

===== In Power Query =====

For large datasets:

  - Choose **Transform**
  - Keep only required columns
  - Set filters
  - **Close and Apply**

===== DirectQuery =====

For real-time data without import:

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