Category Archives for Power BI

Power BI MCSA Certification Training Tips – Part 12: Power Query Custom Functions

To obtain your MCSA: BI Reporting you need to pass two exams: 70-778 (Analyzing and Visualizing Data with Power BI) and 70-779 (Analyzing and Visualizing Data with Excel). However, there is a huge overlap

Continue reading

Managing Relationships in Power BI

When creating reports in Power BI, you will typically create a data model that has several tables. To provide meaningful results, these tables must be linked; so that they can behave like a single unified

Continue reading

Dashboard Alerts on Power BI Usage Metrics

Within each Power BI tenant, usage metrics are available not just for administrators, but for all content-creators. A usage metric report can be generated for any individual dashboard or report. In this

Continue reading

Power BI MCSA Certification Training Tips – Part 11: Connecting to Excel Data

To obtain your MCSA: BI Reporting you need to pass two exams: 70-778 (Analyzing and Visualizing Data with Power BI) and 70-779 (Analyzing and Visualizing Data with Excel). However, there is a huge overlap

Continue reading

Power BI MCSA Certification Training Tips – Part 10: Split Columns by Digit to Non-digit

To obtain your MCSA: BI Reporting you need to pass two exams: 70-778 (Analyzing and Visualizing Data with Power BI) and 70-779 (Analyzing and Visualizing Data with Excel). However, there is a huge overlap

Continue reading

Power BI MCSA Certification Training Tips – Part 9: Split into Rows vs Columns

To obtain your MCSA: BI Reporting you need to pass two exams: 70-778 (Analyzing and Visualizing Data with Power BI) and 70-779 (Analyzing and Visualizing Data with Excel). However, there is a huge overlap

Continue reading

Power BI Business Narration

(G Com Solutions provide Power BI Training in London and throughout the UK.) Power BI reports can be very detailed and consist of many pages. Inevitably, there will be particular insights which it is important

Continue reading

Power BI MCSA Certification Training Tips – Part 8: What-if Parameters

To obtain your MCSA: BI Reporting you need to pass two exams: 70-778 (Analyzing and Visualizing Data with Power BI) and 70-779 (Analyzing and Visualizing Data with Excel). However, there is a huge overlap

Continue reading

Monitoring Power BI Workspaces Using the Admin Portal and PowerShell

G Com Solutions supply Power BI Training in London and throughout the UK. Workspaces play a pivotal role in Power BI collaboration and sharing workflows. The ability to create app workspaces is controlled

Continue reading

Power BI MCSA Certification Training Tips – Part 7: If statements and Conditional Columns

To obtain your MCSA: BI Reporting you need to pass two exams: 70-778 (Analyzing and Visualizing Data with Power BI) and 70-779 (Analyzing and Visualizing Data with Excel). However, there is a huge overlap

Continue reading