Recently Microsoft added the Table Information page to Business Central. See here.
And underlying are these objects:
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…