Getting started with Canvas Data 2

Question

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.

jsimon3 · Answer

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...

jerry_nguyen · Answer

@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.