Download/ Export Power Query data to csv, excel or txt – Power BI Tips & Tricks #25

About this tutorial: Video duration: 6:48 Do you want to export your power query data? In this video I show you how to do it 🙂 How to install R: BI accountant blog: Link to Power BI file: R script: require(gdata) write.table(trim(dataset), file=”C:/writeyourfilepathhere/filename.txt”, sep = “t”, row.names = FALSE) plot(dataset); Looking for a download file? […]

#D49 – Add rows and columns to tables using M in power query

About this tutorial: Video duration: 6:5 In this video, I am going to show you how to add column and rows to a table in power query without appending it. Simply using the M language. #powerquery #curbal #powerbi Here you can download all the pbix file (download 49- community downloads): SUBSCRIBE to learn more about […]

Power BI Tips & Tricks #12: Build your own KPI indicators in Power BI

About this tutorial: Video duration: 8:31 Finally you can create Excel like KPIs in Power BI with this neat trick! Download the example here: Northwind data source: Icons: Keynotes: – Current KPI visuals in Power BI 00:13 – Build the KPI measure 01:12 – Create the icons from web sources 03:15 – Filter your table […]

Power BI Tips & Tricks #02: Create a custom calendar in Power BI

About this tutorial: Video duration: 8:42 Here I show you how to create a custom calendar in Power BI. Download the calendar file: SUBSCRIBE to learn more about Power and Excel BI! Our PLAYLISTS: – Join our DAX Fridays! Series: – Power BI dashboards for beginners: – Power BI Tips & Tricks: – Power Bi […]