Select Page

Importing XLSB into Power BI

I had a question from one of my online Power BI Training students just this week who was struggling to import data from a large *.xlsb Excel file.  I suggested she save the file as an XLSX file and try again – and that worked a treat.  But the question is why?  I had...

Power BI Dataflows, and Why You Should Care

Microsoft recently released a new feature in Power BI called “Dataflows”.  You may have seen it pop up in a recent release of Power BI Desktop under HomeGet DataPower BI Dataflows (beta) as shown below. It is also visible when you log into PowerBI.com and go to an App...

Power BI is an Enigma, so What to Do?

Power BI is an enigma.  On the surface Power BI is an alluring product that promises to change your world of data analytics for the better – and indeed it can and will.  But sitting just beneath the surface, hidden from view, is the reality that there are many things...

Create a Power BI Slicer Panel

There is nothing worse than having a Power BI report that has 50% of the space taken up with slicers.  When this happens, you only get half the page to visualise the actual data.  But on the flip side, if you don’t have the slicers it can be harder for the report...