Hello,
Our company recently migrated our NAV based on an Azure SQL Server to a SaaS - Business Central.
I need to create some Power BI reports with data from all of the companies.
On the SQL Server I had administrative access and could create some views that do UNION ALL for the same table (like Accounts or Customers) for all companies.
Is there any way to achieve this "union all" in Business Central without using other services like Azure Data Lake as I've seen into another forum post (Access data from all companies in one central extension)?
Kind Regards,
Lucian