Our PowerBI connector supports all major bi views and tables from your Fortnox dataset. However, you may need to add something more to perform a specific analysis of your data. Here is how you can easily do it.
Open your *.pbix file in PowerBI desktop application and go to Transform Data tab.
In the list of Queries, pick any table of your choice, right-click on it, and use Duplicate option. It doesn’t matter which table you will choose at this step - this will be a draft for your new table.
Your copy usually appears at the end of the list with (2) as suffix to it’s name. Locate and give it any name you’d like using Rename.
Then, go to Advanced Editor.
First of all, make sure to define a dataset where your table is located. All fact and dimension tables are in fortnox_bi, but you may need custom dataset for specific queries made in BigQuery or fortnox_api for raw data.
Finally, write the name of your table instead of the name of the table you duplicated. You do not need to change anything else in the Advanced Editor.
Once done, click Save & Apply to apply your changes and exit the Transform Data mode.
Your data will be loaded once again. You will see your newly added table in the Data right pane.
But what if you are building your own report outside of our template?
Start from Get data button from your Home ribbon. Select More…
Enter “BigQuery” in the search box and select Google BigQuery, then click Connect.
In the pop-up widnow, open Advanced options and enter “enhanza” as your Billing Project ID and as your Project Id.
In the Navigator menu, open enhanza project and browse through the dataset available to you. Select a table that you want to load and press Load button.
When prompted, select DirectQuery as a Connection setting and press OK.
Brilliant work! Once the load is finished, you now have access to a table of your choice.
Stay on top of your data with Enhanza!