The Power BI Can-I-Have-It-In-Excel tool

Get an Excel table connected to your Power BI report

Power BI Analyse in Excel only provides connected pivot tables.
This tool generates the connection file for a connected Excel table.

  • Find your dataset id or url on or in your Power BI workspace
  • Enter a table name or DAX code
  • Click on the generated link to download the odc connection file
  • Open the odc file, et voilĂ !

Download your connection file:

Or share this link: