Calculated tables are helpful tools when you want to add calculated values to the model instead of calculating them on the fly.

Getting viable data from an Excel workbook into Power BI for data visualization purposes takes some specific preparation. Here is what you need to do.

But Power BI has been tied to very Microsoft ways of working – Excel, Silverlight and SQL Server. That's changing in the new release which has just been unveiled, says James Phillips.