Question

You are building a Power BI report that must include daily currency exchange rates. The rates are published on a public government website as an HTML table on a static page whose URL never changes. You need to connect to this data so it can be refreshed on a schedule in the Power BI service. Which approach should you use to get the data?

Accepted Answer

Use the Web connector, point it at the page URL, and select the table Power Query detects in the navigator.

Answer

Manually copy the table into Excel each day and import the Excel workbook using the Excel connector.

Answer

Use Enter Data to paste the current rates into a manually created table in Power Query.

Answer

Use the OData feed connector and supply the website URL as the service root.