- What should I do when I get a 404 error when connecting a form to PowerBi?
The 404 error on PowerBi means the form ID you are trying to connect does not exist or you do not have the correct permission to the project where the form is located. Check and confirm that you have defined the correct form ID or you have at least can view and download permission to the project where the form is located. See this guide on how to find the form ID. - How can I connect a filtered dataset to PowerBi?
If you have a filtered dataset, you are required to use the dataview endpoint instead of to data endpoint for a normal form. The URL will change to https://api.ona.io/api/v1/dataviews/dataset_id/data.csv,where dataset_id is the last part of the URL when you open filtered dataset. - How can I solve the timeout error when I have a form with a large number of records?
When you have a form with a large number of records, you are likely to get the timeout error when you try to connect it to PowerBi. To solve the issue, you can apply pagination, which will allow you to connect forms in batches of 10k records for each request, and then later apply the UNION function to union the batches of records together in PowerBi. See this guide on how to apply pagination. - Can I create a report and refresh the data automatically?
You can add a scheduled refresh, which is supported on PowerBi online after you have published your report. To schedule an automatic refresh, log into PowerBi online and select the workspace where you published your report created from the connected forms. Hover over the report’s dataset and click on the three dots to open more options. Then, select the settings option to schedule the refresh period as shown in this guide. - Can I import data with labels to PowerBi?
Importing data with choice labels to PowerBi is not supported as the PowerBi web connector does not support data manipulation. - Does the Ona to PowerBi connection support incremental refresh?
At the moment, the system does not support incremental refresh
- Can I embed the PowerBi dashboard into a form in Ona?
At the moment, the system does not support the external dashboard embedded in the platform. There is ongoing work to support an external dashboard embed, and we expect it to be supported soon. - What can I do to solve PowerBi Error on the missing column when a form has been replaced or updated?
- On PowerBi, open the query editor on the source that you want to refresh. Click on the three dots to open more options and select Edit Query.
- On the Power Query Editor, click the View tab.
- Click on Advanced Editor to open the editor code.
- The Advanced Editor lets you see the code that Power Query Editor is creating with each step. On the editor, increase the number of columns to a larger number and save the changes.
- Go to Home page on Power Query Editor, and click the Close and Apply tab to save the Query changes.
