How can we help?
Welcome to Curbal Learning Portal. Search for answers using the search box below, or create a request for a video or blog if you cannot find your answer.
Popular searches: DAX Glossary | Guided courses | Request a video
-
Power BI
-
Power BI by Topic
-
Python
-
Overview
- Articles coming soon
-
Get data
-
From File
-
From CSV
-
From Excel
-
From folder
-
From GZIP
-
From JSON
-
From PDF
-
From ZIP
-
SharePoint folder
-
-
From Online Sources
-
From GitHub
-
From Google Sheets
-
From REST API
- How to get data from a REST API in Power BI for rookies
- How to do Pagination on a REST API in Power Query (Part 1) | List.Numbers
- How to do Pagination without knowing the number of pages (Part 2) in Power Query | List.Generate
- How to create a real time dashboard with Flow (Power Automate) and Power BI
- Use Google Maps API with Power BI Desktop
- How to connect to a SOAP API in Power BI or Power Query
-
From Web
-
OneDrive
-
-
From Power Platform
-
From Social Media
-
-
Concepts
-
Manage sources
- Avoid hardcoded paths in Power Query
- Advanced setting to add query parameters to your source paths in Power Query
- How to keep relationships and measures when changing sources in Power Query
- Avoid refresh errors with missing columns in Power BI/Power Query
- Fix the "Enter data" limitation in Power Query
- Manage/ Edit data source credentials in Power BI Desktop
-
M connectors
- Is Power Query.....? | Google's most asked questions on Power Query
- 2 FREE Cheat Sheets for Power BI
-
Transform data
-
By type
-
Column
- Manage header names and order of columns in bulk in Power Query
- How to sort multiple columns using the M Language in Power Query
- Add/Append rows and columns to tables without merging using M in power query
- Advanced Concatenate/ Merge columns with Power Query
- Advance way to reorder Power Query columns without breaking your queries
- Dynamically add missing columns in Power Query
- Managing changing column names in Power Query
- Change column names dynamically with parameters in Power BI
-
Headers - Manage header names and order of columns in bulk in Power Query
- Trim or remove spaces on column headers with Power Query
- Trim / remove all spaces from column headers in bulk in Power BI/ Power Query
- Add prefix to headers in Power Query
- Managing changing column names in Power Query
- How to change column headers to upper or proper case in Power Query
- 8 common column headers transformations you will need in Power Query
- Change column names dynamically with parameters in Power BI
-
Fill up/down
-
Date
- Create a Date/Time calendar
- Create a custom calendar in Power BI using Power Query
- Equivalent of CALENDARAUTO in Power Query
- Share calendars with your organization in Power BI
- List dates between two dates in Power Query - Part 1
- List of dates between two dates based on different schedules in Power Query - Part 2
- Convert UTC datetime to local time zones in Power Query
- Working hours without Holidays, weekends and by country in Power Query
-
Row
- Promote a row to a column in Power Query
- Get previous row in Power Query - EXPLAINED
- Insert blank rows at each category in Power Query
- Split multiple columns into rows without errors in Power Query
- Add a grand total row to a table in Power Query
- Get only the rows you need in Power Query from your files
-
Text
- Quickly change data types with M language in Power Query
- A technique to count anything in Power Query and some in DAX too
- Count the number of words in a text in Power Query
- Extract in Power Query (LEN, LEFT, RIGHT in Excel)
- Add Leading and ending zeros with Power Query
- Concatenate a text with quotation marks in Power Query
- Regular Expressions or RegEx in Power BI
- Split text by capital letters and non/digits in Power Query
-
Time
-
-
Filter Tables
- How to filter a table to show only most recent date by group in Power Query - Part 1
- Keep most recent record on a table with Power Query | Improved solution - Part 2
- Import tables or pages based on a word or phrase from a pdf in Power Query
- Filter your Power Query columns by ANY CONDITION!
- Dynamically find and filter header rows and promote them in Power Query
- Avoid filtering issues in Power Query
- Get only the rows you need in Power Query from your files
-
Combine data
-
Join/ Merge /Append
-
Pivot/Unpivot/Transpose
- Transpose, pivot or unpivot in Power Query?
- A practical and common case to practice table transformations in Power Query
- How to fix the "Too many elements in the enumeration to complete..." pivot error in Power Query
- Unpivot complex tables in Power Query
- How to pivot tables with uneven number of columns
- Unpivot a complex table (multiple columns) in Power Query
-
-
Nested Tables
- How to filter a table to show only most recent date by group in Power Query - Part 1
- Keep most recent record on a table with Power Query | Improved solution - Part 2
- How to fix the "Too many elements in the enumeration to complete..." pivot error in Power Query
- Add index to nested tables in Power Query
- How to Group by in Power Query
- Running totals by subcategory in Power Query -Part 2
-
Functions
-
-
M Language 101
-
Improve performance
- The performance analyzer in Power Query -Part 1
- File to analyze json file from the Performance Analyzer in Power BI - Part 2
- Query folding to improve Power Query /BI performance
- Flat tables or models in Power BI? Which one should I choose and why?
- Troubleshoot Power Query queries with Query Diagnostics tool
-
Manage queries
-
M Query Parameters
- Change column names dynamically with parameters in Power BI
- Advanced setting to add query parameters to your source paths in Power Query
- Avoid hardcoded paths in Power Query
- Use query parameters to filter your Power BI reports
- Change M query parameters in Power BI service
- Dynamic M Query parameters explained: How it works, security concerns and limitations
-
Document Queries
-
-
Power Query Patterns
- Working hours without Holidays, weekends and by country in Power Query
- List of dates between two dates based on different schedules in Power Query - Part 2
- List dates between two dates in Power Query - Part 1
- Create Hierarchies in Power Query
- Running totals by subcategory in Power Query -Part 2
- Running totals in power query - Part 1
- Advanced hierarchies in Power Query
- Create allocation table and visualize it in a Gantt Charts with matrix in Power Query
-
Manage errors
- How to deal with errors in Power Query (2 ways)
- Handling errors in Power Query with try > otherwise
- Avoid refresh errors with missing columns in Power BI/Power Query
- How to fix the "Too many elements in the enumeration to complete..." pivot error in Power Query
- Avoid filtering issues in Power Query
- Fix the "Enter data" limitation in Power Query
- Troubleshoot Fill Up/Down cells with values above or below in Power Query | Fill up and down functions
- New way of Dealing with errors in Power Query
-
Modeling 101
- Introduction to data modeling in Power BI - Part 1
- Snowflake vs star vs galaxy schemes in Power BI - Part 2
- Flat tables or models in Power BI? Which one should I choose and why?
- Best Practices for Power BI modeling
- What are calculated tables in Power BI and how to use them?
- How to solve sort order error: "We cannot sort the 'A' column by 'B'. You cant have more than ..."
-
Advanced Modeling
-
Understanding Relationships
- Beginner's Guide to Relationships in Power BI
- Building relationships between tables when both have duplicates
- Manage relationships with CROSSFILTER in Power BI
-
M2M/ Bidirectional
-
Inactive relationships
-
DAX 101
- #1 The basics of the DAX Language
- #2 Introduction to filter and row context
- #3 5 things I wish somebody told me when I started learning DAX
- #4 What is context transition in DAX?
- #5 Order of evaluation of DAX formulas
- #6 Scalar vs table vs other functions in DAX
- #7 My beginner's DAX mistakes, ......what are yours?
- #8 Why is DAX so difficult to learn?
-
Vertipaq
-
DAX Patterns
- Last accumulated value in DAX
- Create Hierarchies in DAX
- A technique to count anything in Power Query and some in DAX too
- Calculate previous row using DAX | Reverse cumulative values
- Allocation calculations in DAX | GENERATE
- Allocation calculations grouped by period | GROUPBY , CURRENTGROUP
- Get selected values from slicers using DAX
- Running/ Cumulative totals (w Pareto chart)
-
Statistics with DAX
- Binning, Frequency and relative frequency with DAX
- MEDIAN, AVERAGE, MEAN, MODE | The Bill Gates Effect
- Standard deviation explained | Who is the best player, LeBron or Durant?
- NORM.DIST | Predicting Kevin Durant Scores
- NORM.INV | Predicting Kevin Durant top scores
- Forecasting with DAX in Power BI
- Calculate quartiles in Power BI with DAX | PERCENTILE.EXC and PERCENTILE.INC
- Calculate confidence intervals with DAX | CONFIDENCE.T and CONFIDENCE.NORM
-
Improve performance
- Analyze memory usage in Power BI to improve performance using DMV queries
- Make your Direct Queries run faster in Power BI | Assume referential integrity
- The Formula (FE) and Storage Engine (SE) explained
- Flat tables or models in Power BI? Which one should I choose and why?
- Why you should disable Auto Date/Time
-
PBI Visuals
- Custom sort order for axis, columns, legends in Power BI
- Show rows with no data in Power BI visuals
- How to quickly align visuals in Power BI
-
Matrix
-
Maps
-
Images
-
Line chart
-
Slicers
-
Infographics
-
Heatmaps
-
HTML
-
Report navigation
-
Advance daviz techniques
-
Field Parameters
-
Key Performance Indicators (KPI)
- Good KPIs, Bad KPIs and the North Star metric | A Power BI Goals 🏆 pre-guide
- Leading or lagging KPIs, what should I use? | Netflix use case
- Add KPI icons in Power BI based on formula results using DAX
- Add colored KPI icons to a Power BI matrix
- Custom KPI 🔥 icons/ gifs in Power BI !!
- How to create KPIs in Power BI using SVG images
-
Drillthrough
-
Titles
-
Conditional Formatting
-
Dynamic Formatting
-
-
Charticulator
-
Complete Chart Tutorials
-
Radial Charts
-
-
How to in Charticulator
-
-
JSON Themes
-
Real time reports
-
Report Design
- How to design stunning Power BI reports: From initial sketches to final result
- Blurred images in Power BI? Here is how to fix it.
- An Eyedropper for Power BI !!
- 3 ways to align your visuals in Power BI
- Automatic custom backgrounds for Power BI Desktop
- How to add ANNOTATIONS to a chart in Power BI to provide an explanation or more context!
- POWERFUL storytelling technique in Power BI from STORYTELLING BY DATA book
-
Share your reports
-
to Web
-
to PowerPoint
-
to Excel
-
to SharePoint
-
to PBI workspace
-
to PBI app
-
to PDF
-
to PBI Dashboard
-
-
Alerts
-
Data security
-
Monitoring
-
Permissions
-
Licenses Explained
- Update Power BI Desktop automatically
- Add measures in bulk to your Power BI file without external tools
- Create a data connection shortcut in Power BI (with PBIDS files)
-
Alerts
-
Export Power BI data
- Export data to excel in Power BI at the click of a button
- Append exported Power BI data to Excel, AUTOMATICALLY 😎
- Automatic export of Power BI data to a local folder
- Export Power BI data to Excel / CSV (up to 100.000 rows)
- Export Power BI data to Excel / CSV (NO row limits!)
- Export Power BI data to Excel / CSV (NO row limits – no headers)
- Change column names when exporting data from Power BI
- Configure Smart Alerts in Power BI
-
Refresh data
- Refresh Power BI reports every second or minute!
- Avoid refresh errors with missing columns in Power BI/Power Query
- How to refresh web sources in Power BI service
- Automatic Page Refresh in Power BI Desktop
- All you need to know about incremental refresh for PRO licenses
- Set up Incremental refresh for any source in Power BI
- Create a Power App from scratch that refreshes a dataset in Power BI
-
Power Automate
-
MS Word
-
Power Apps
- Import a Power App into Power BI
- Store data from Power Apps in SQL, approve it in Power Automate and use it in Power BI
- Time tracking solution ⏱ in Teams with Power Apps and Power BI
- Create an excel based budget app with Power Apps and use it in Power BI
- Create a Power App from scratch that refreshes a dataset in Power BI
- Modify individual cells without write permissions in Power BI | Write back in Power BI
-
MS Forms
-
MS Outlook
-
AI
- Articles coming soon
-
R
- Articles coming soon
-
Python
- Articles coming soon
- Create a Date/Time calendar
- Create a custom calendar in Power BI using Power Query
- Working hours without Holidays, weekends and by country in Power Query
- Equivalent of CALENDARAUTO in Power Query
- Share calendars with your organization in Power BI
- List of dates between two dates based on different schedules in Power Query - Part 2
- Convert UTC datetime to local time zones in Power Query
- List dates between two dates in Power Query - Part 1
- Binning, Frequency and relative frequency with DAX
- MEDIAN, AVERAGE, MEAN, MODE | The Bill Gates Effect
- Standard deviation explained | Who is the best player, LeBron or Durant?
- NORM.DIST | Predicting Kevin Durant Scores
- NORM.INV | Predicting Kevin Durant top scores
- Forecasting with DAX in Power BI
- Calculate quartiles in Power BI with DAX | PERCENTILE.EXC and PERCENTILE.INC
- Calculate confidence intervals with DAX | CONFIDENCE.T and CONFIDENCE.NORM
- Export Power BI data to Excel / CSV (up to 100.000 rows)
- Export Power BI data automatically to OneDrive
- Change column names when exporting data from Power BI
- Automatic export of Power BI data to a local folder
- Filter Power BI exports with Power Automate
- Filter the data in Power BI before you export it to excel using Power Automate
- Append exported Power BI data to Excel, AUTOMATICALLY 😎
- Export Power BI data to Excel / CSV (NO row limits – no headers)
- Filter Power BI exports with Power Automate
- How to create a real time dashboard with Flow (Power Automate) and Power BI
- Filter the data in Power BI before you export it to excel using Power Automate
- Paginated Reports with MS Word and Power BI
- Send MS Forms responses to email using Power Automate
- Automatic export Power BI data to Excel / CSV - Run a query against a dataset
- The Python Crime Game
- Bite 1: Print, user input, variables
- Bite 2: Functions, global and local variables
- Bite 3: if statements
- Bite 4: Validate user input in python
- Bite 5: Connect to a SQL dataset and query the tables
- Bite 6: For loops, try except in Python
- Bite 7: Get Lat, long and create new Geo table
- 1 dataset, 100 matplotlib visualizations
- 1 of 100: Stacked bar chart in matplotlib
- 2 of 100: Gauge chart in matplotlib
- 3 of 100: Lollipoll chart in matplotlib
- 4 of 100: Stacked bar chart 3D in matplotlib
- 5 of 100: Hexagon bin chart in matplotlib
- 6 of 100: Horizontal Stacked bar chart in matplotlib
- 7 of 100: Scatter plot in matplotlib
-
Area Charts
- Area charts in Matplotlib
- 9 of 100: Square area chart in matplotlib
- 11 of 100: Proportional Area chart in matplotlib
- 12 of 100: Nested Proportional Area chart in matplotlib
- 29 of 100: Overlapping Area chart in matplotlib
- 51 of 100: Area chart in matplotlib
- 60 of 100: Area chart in matplotlib
- 63 of 100: 3D Area chart in matplotlib
-
Bar Charts
- Bar charts in matplotlib
- 25 of 100: Bar chart in matplotlib
- 27 of 100: Clustered bar chart in matplotlib
- 33 of 100: Bar chart in matplotlib
- 83 of 100: Stacked bar chart in matplotlib
- 39 of 100: 3D bar chart in matplotlib
- 36 of 100: Linked bar chart in matplotlib
- 99 of 100: Bar chart in matplotlib
-
Stacked bar chart
- 1 of 100: Stacked bar chart in matplotlib
- 6 of 100: Horizontal Stacked bar chart in matplotlib
- 21 of 100: Semicircular stacked bar chart in matplotlib
- 24 of 100: Stacked progress bar chart in matplotlib
- 47 of 100: Stacked bar chart in matplotlib
- 58 of 100: Stacked bar chart in matplotlib
- 88 of 100: Stacked bar chart in matplotlib
- 90 of 100: Marimekko chart in matplotlib
-
Dot Plots
-
Dumbbell chart
-
Heatmap
-
Line Charts
-
Pie Charts
-
Polar Charts
-
Radar Charts
-
Proportion plots
-
Scatter Plot
-
Slope Charts
-
Tables
-
Gantt Charts
-
Tornado
-
Waffle Charts
-
Lollipoll Charts
-
Hexagon bin plot
- Articles coming soon
-
Square Area Charts
- Articles coming soon
-
Proportional Area chart
- Articles coming soon
-
Radial Lines chart
- Articles coming soon
-
Donut Chart
- 14 of 100: Donut chart in matplotlib
- 31 of 100: Semicircular Donut chart in matplotlib
- 50 of 100: Donut chart in matplotlib
- 57 of 100: Donut chart in matplotlib
- 82 of 100: Multi-level donut chart in matplotlib
- 93 of 100: Donut scatter chart in matplotlib
- 64 of 100: Donut chart in a map in matplotlib
- 94 of 100: Multi-level donut chart in matplotlib
-
Other
- 5 of 100: Hexagon bin chart in matplotlib
- 10 of 100: Scatter chart in a diagonal in matplotlib
- 13 of 100: Radial chart in matplotlib
- 15 of 100: Progress chart in matplotlib
- 18 of 100: Arc chart in matplotlib
- 22 of 100: Curved stacked bar chart in matplotlib
- 26 of 100: Semicircular scatter chart in matplotlib
- 28 of 100: Nested half circles chart in matplotlib
-
Bump Chart