Power BI and Canvas Data

Hello,

I am being asked to pull in metrics from Canvas into Power BI. Any assistance would be appreciated. I have reviewed the Developer Key Creation. Unsure how to tie it together.

Thanks,

Find more posts tagged with

Accepted answers

All comments

Robert

Hi @mohammad_asim

Welcome to the Canvas Community. I have not used Power BI, but I imagine it's similar to Tableau in that you'll still have to get the files and load them to a data source or use them flat.

Here's a discussion with some people who've usedPower BI

Here are some additional resources for awesome-canvaslms#CanvasData

Including the guides, setup, and Canvas Data CLI, queries, discussions etc.

The CLI tool helps you get the files.

Then, loading them into a data source depends on your tech and preferences. I use Embulk, some use SSIS, or any number of Amazon solutions including Build a Canvas Data Warehouse on AWS in 30 minutes!

Looking at your profile/email... I talked with Nicole last spring, feel free to email me if that helps.

102802029139482

Hello, I have recently passed the Microsoft Power BI Data Analyst PL-300 Exam and encountered the same issue during my exam preparation. To pull metrics from Canvas into Power BI, you can follow these general steps as they worked perfectly fine for me:

Generate Developer Key:
- Make sure you have administrative access to Canvas.
- Go to the Canvas Developer Key creation page and generate a developer key. This key will be used to authenticate your requests to the Canvas API.
Understand Canvas API:
- Familiarize yourself with the Canvas API documentation to understand the available endpoints and data you can retrieve.
Power BI Web Connector:
- Open Power BI and use the Web connector to connect to Canvas API. In Power BI Desktop, go to "Home" > "Get Data" > "Web" and enter the Canvas API endpoint URL.
Authentication:
- Set up authentication using the developer key you generated. You may need to use OAuth or API key authentication, depending on Canvas's requirements. Input the key in the appropriate authentication section of the Power BI Web connector.
Query Data:
- Construct queries in Power BI to pull the specific metrics you need. This involves specifying the API endpoints, parameters, and any filters required.
Transform and Load Data:
- Use Power BI's Power Query Editor to transform and shape the data according to your reporting needs. This may include cleaning data, renaming columns, or merging tables.
Data Modeling:
- Model the data within Power BI by defining relationships between tables and creating calculated columns or measures.
Create Visualizations:
- Build visualizations based on the metrics you've imported. Drag and drop fields onto the report canvas to create charts, tables, or other visual elements.
Schedule Data Refresh:
- If you want the data to be updated automatically, set up a scheduled refresh in Power BI to periodically pull the latest metrics from Canvas.

Remember to handle sensitive information, such as API keys, securely. Also, be mindful of Canvas API rate limits to avoid exceeding them during data retrieval. If you encounter specific issues or have more detailed questions, feel free to provide additional information for more targeted assistance.

Unanswered Questions

EDUCAUSE Insights: Data and Decision-Making
EDUCAUSE is full of inspiration, whether you’re onsite or following from afar. Join the evolution by sharing what sparks your curiosity, the questions you have, and the insights you discover. We'll learn from each other, expand our networks, and strengthen our Community. Your perspective matters, and the more we share,…
Problems with GraphQL in User Pageviews reports
Prompted by the most recent Canvas release notes, we looked into the Page Views feature, and we were happy with the new documented changes. However, we notice that more user actions are done by GraphQL API, which does not provide details in the page view report, either in the GUI or in the CSV file download. We and most…
Metrics Easy Button
I am currently teaching five courses this semester with more than 70 students. To track their progress, I currently have to review each course and section individually, which is very time-consuming. Ideally, I would like to consolidate key information for all students into a single Excel file—showing class attendance…
Analytics API / Metrics calculation logic
Hello, We are currently using the Analytics API provided in the Instructure Developer Documentation Portal to retrieve certain metrics-related data. We would like to know if it’s possible to replicate these datasets using the Canvas Data Platform (CDP), instead of relying on API calls. For example, could you please advise…
CD2: Enhanced Rubrics
Is there a way to tell via CD2 if a course is using Enhanced Rubrics? I didn't see it in the entity diagram for Rubrics table, but I might have missed something... Thanks Ian