SimpleBI

Have you worked with an Excel or CSV file that changes slightly their column names? Whatever the reason, this seems to make your Power BI refresh crash.As you know, Power Query is very susceptible to any change, especially using Functions such as Table.ReorderColumns or Table.SelectRows. To solve that problem we have developed a function called […]

PowerBI allows to create reports with ease but that doesn’t mean that they would look good without a major effort. That’s why we have create a list of 3 tips that can help to achieve professional PowerBI reports. The difference between a corporate report versus a basic one is based on a few rules and […]

In the era of Machine Learning, there is still an uncountable number of organizations that rely heavily on systems of the 80’s – excel spreadsheets. The problem is not the tool per se, but the strategy across the organization,  where data is imprisoned in different silos, full of mistakes and where data governance is nonexistent. Creating […]