How to backup a single table in SQL

Posted on October 14, 2021November 13, 2021 by Paul

Before running and update or delete queries, make sure you backup your database. But sometimes you don’t want to backup the entire SQL Database. Sometimes you just want to backup a single table, run your...read more

Power BI – Frequently Asked Questions

Posted on June 14, 2021November 13, 2021 by Paul

Power BI is a powerful reporting tool. It is part of the Microsoft Power Platform and works very well with a variety of Data Sources starting with text, coma separated value files, Excel files and...read more

Power BI Error: Information is needed in order to combine data

Posted on June 14, 2021November 13, 2021 by Paul

I had this happen to me on a dataset that was refreshing OK in the Power BI Desktop application but not refreshing in the service. The service was giving the error: "Information is needed in...read more

Power BI – Filter SQL Data before import

Posted on April 9, 2021November 13, 2021 by Paul

Sometimes you need to filter the source data before loading into POWER BI Desktop. If you have a large SQL database with millions of records and you only need the records in the past few...read more

What is Power BI Desktop

Posted on September 11, 2019November 13, 2021 by Paul

Power BI Desktop If you look in the Microsoft Store you will find two applications that you can install on your Windows PC. One is Power BI Desktop and the other is Power BI Mobile....read more

What is the Power BI service

Posted on September 8, 2019November 13, 2021 by Paul

If you are just starting with Power BI you might be confused of all the Power BI products you encounter. Power BI ServicePower BI DesktopPower BI mobile app The good news is, they are all...read more