Table of Contents
...
Projects are linked to journals – project_id is made negative, a dummy entry in orders is created to satisfy database integrity. So project 100 would be store as order_id -100 in journals.
the link between vbi_journal_lines and orders is source_id to order_id.
| Note | ||
|---|---|---|
| ||
If you connect to the reporting using Microsofts SQL Server Management Server ( a free tool) to connect to the reporting server you will see diagrams that have been created to explain the data connections. |
...
The ideal place for this database is in SQL Azure - it is cheap and in the same place as Power Bi Online so data does not travel across your network for designing and refreshing the report data.
- For those that like excel it can also connect to Azure... https://blogs.technet.microsoft.com/office_online_support_blog/2015/10/29/excel-online-refreshing-data-to-a-sql-azure-database/ and https://powerbi.microsoft.com/en-us/documentation/powerbi-azure-sql-database-with-direct-connect/
...
Then Select the Tables Required
Select the tables to view
...