Power BI Desktop allows you to connect your data directly from DataScope.
1. To connect your data:
Select Get data from the Home menu. Selecting the down arrow or the Get Data button text, displays the Most Common data types menu as seen in the following image:
2. Selecting More ... from the Most Common menu displays the Get Data window. You can also open the Get Data window (and skip the Most Common menu) by selecting the Get Web icon:
3. After this you need to add the link https://www.mydatascope.com/api/external/answers?token=API Key of your account, where your API Key can be obtained at the Integrations section of the DataScope web platform:
All your requests must contain your API key, that has the following format:
Authorization: b1cd93mfls9fdmfkadn23
Then you must go to the form you want to link and get the ID.
ID: the form ID. On the form you want to obtain the ID, click on Configure> Modify App, according to the image below to obtain it's URL:
*On this example, the Form ID is 460700.
Following this example, at Step 3 you would add the following link:
You will be able to see all the forms completed in the last 7 days, or you can add parameters such as extend the date range, specific forms or more that you can find in the documentation below:
Example:
=Json.Document(Web.Contents("https://www.mydatascope.com/api/external/answers?token=b1cd93mfls9fdmfkadn23&start={props.set(""2019-10-01"")}&end={props.set(""2020-01-01"")}&form_id=460700"))
2. Working with your data:
You can further transform the data into a Table:
And select relevant information for your analysis:
After that you will be able to make the charts and graphics that matches your needs, with the information that is most relevant to you and your business.
----------------------------------------------------------------------------------------
Related Articles
----------------------------------------------------------------------------------------