Yes, ditto. I am also very keen to start working on a project to get Canvas Data into PowerBI but am struggling even to get to first base at the moment.
I have an admin role in Canvas (and a valid API key to access our data on the Canvas Data Portal) but am currently a novice with this type of work.
I've read through the below *community article relating to downloading the data (which is possible for me, but only by downloading one file at a time!) but I just need some further guidance on how to correctly authenticate using the suggested scripts and then store and import into PowerBI (again, I'm trying to learn this as I go along).
*Beautifully concise article about getting our hands on the canvas data from Jame Jones [Artical link] (but even so, I'm still trying to work it out).
Would be great to collaborate with you if you wanted to figure out how to make use of Canvas Data and create some usable analytics.
I'm hoping some savvy/knowledgeable soul out there in the community can guide us through with concise download examples and templates for reporting.
Once again, please feel free to reach out to me if you want to collaborate and let's see if the community have an 'idiots guide' for me.
Many thanks for the initial post. Rod.
ps, there was a reply to a post I have read from @a1222679 with some example templates, but I'm not authorized to view the example content [Article link]
pps, I don't have a budget to use AWS, which is another suggestion I've seen
I'm also in the same boat with PowerBI. I'm as far as unpacked data via CLI, but actually convincing PowerBI to cooperate has been unsuccessful. I'm simply trying to show progress from pre and post quiz results.
would you please help me out on how to connect powerbi with canvas data services we tried all the methods by the canvas team but their description is pretty vague and tried few things based on community thru which we were able to get the DIM & Fact files but we are unable to find the relations to connect the data.
Could you please share some ideas on how to go about it.
We tried connecting using the Data Service facility which helps in connecting SQS. But that were only the events and not the actual information of that event.
The we explored another option - The CLI Data tool which helps in the canvas data export gives all the event details but we are not able to understand the data mapping. https://portal.inshosteddata.com/docs is not so helpful.