Quick Tip: How do I use Table Information in Power BI?

Recently Microsoft added the Table Information page to Business Central. See here.

And underlying are these objects:

  • Table Information (8700, List)
  • Table Information (2000000028)

So I was thinking, hey let’s use this in Power BI. Then my first thought was to create a query object using the Table Information table as a data item, but unfortunately I got the following error:

Damn…. But hey, there’s another way, let’s use the Reporting Data Setup wizard to expose the page as a web service:

Now the page is published as a web service and you can use Power BI Desktop to connect to it:

Cool, now click Close & Apply and let’s get started…

Comment List