Getting started with Canvas Data 2

[petern]

Can someone help provide step-by-step instructions to get the data from Canvas Data 2 into Power BI?

The help guides are too high level for me and only work up to environment variables.  When I try to run dap in command prompt, it fails to recognise anything.

[jerry_nguyen]

@petern 

What errors are you getting? Have you added the API/Secret to the Environment Variable?

There are two ways you can download and load data to Power BI

1. Download a plain-text CSV file and load it to Power BI manually using this command: dap snapshot --table table_name --format csv

2. (Recommended) Load data to a database then connect Power BI to that data source. This will require you to set up a SQL server (Either Postgres or MySQL)

If you need help setting this up, feel free to send me a PM.

[petern]

Thanks @jerry_nguyen 

I'm going to see if the IT admin at my place can help set up the server for me as you suggest.  

I added environment variables but was still getting the command not found error (trying to run dap).

[jsimon3]

if your using PowerBi more than likely You have a paid SQLServer license sitting somewhere... Which means you’ll probably be utilizing T-SQL.
Also, you can pass the IT dept. the link to this https://github.com/uvadev/PullCanvasData2/pkgs/nuget/PullCanvasData2 package that is a simple nuget that would allow them to pull in CD2 in the way that they want or prescribe to...