Tag: Loading and Transformation

Create Power BI Report To SQL Server Using R Script

Today, I will talk about a cool feature of Power BI where you can fix your data from the Power BI desktop or Power BI web service to SQL server. We encountered a situation where we had to pull data from Power BI desktop to SQL server and use R script. In order to demonstrate

Continue reading

Enter Data In Power BI: How To Use It For Data Entry

Enter Data In Power BI: How To Use It For Data Entry

In this blog post, I want to take a closer look at the Enter data in Power BI and show you ways how to use it. Before, in most cases, we brought in data by connecting to a data source. That won’t change of course, but Power BI also offers ways to manually create tables,

Continue reading

Data Loading And Transformation Best Practices

Data Loading And Transformation Best Practices

I’d like to present the best practices I’ve adopted while preparing Power BI reports. Over the past few years, I’ve consumed many online resources on data loading and transformation which have been instrumental in my journey, but I quickly became overwhelmed by the content, so I ended up making my own notes. You can watch

Continue reading