Page Comparison

...

• CSV download: use the endpoint on an incognito web browser’s taba web browser. You might need to right-click the text and Save As into a local CSV file.

• Excel: go to the Data ribbon → From Web → paste the endpoint:

  • Click Ok.

  • Set the Delimiter to Comma.

  • If the table has undergone structural changes since the last extraction on this Excel install (cache), click the Refresh icon.

  • Click Load.

  • If you see errors on the Queries & Connections panel, mouse over the errors section and click on it to open the Power Query Editor. Scan through the shown tables for “Error”, click on them to get a description on the bottom panel. The most common fix to these errors is by going to the main query in Power Query → select Changed Type on the right panel → edit the Table.TransformColumnType expression (drop down at the top of the table), for instance, a column set to Inte64.Type must be changed to type text.

  • You might need to pivot/unpivot the table to view it like the Tableau view.

• Power BI: Get data → Web → paste the endpoint → Ok → Anonymous → Connect:

  • Set the Delimiter to Comma.

  • If the table has undergone structural changes since the last extraction on this Excel install (cache), click the Refresh icon.

  • Click Load.

  • If you see errors on the Load panel, click View errors to open the Power Query Editor. Scan through the shown tables for “Error”, click on them to get a description on the bottom panel. The most common fix to these errors is by going to the main query in Power Query → select Changed Type on the right panel → edit the Table.TransformColumnTypes expression (drop down at the top of the table), for instance, a column set to Inte64.Type must be changed to type text.

...