This is a post about a feature request, that definitely would make my life easier (and I guess others’ too): Evaluation context and its transition is one of the hardest (…) Read more
Posts Tagged ‘Power BI’
Right Aligning Text in Power BI: Format Improvements for Easy Profit&Loss Reports
Edit 14-Dec-2017: Now that we can right-align text measures in PowerBI, a SWITCH-measure like here: http://www.thebiccountant.com/2017/04/24/kpis-in-easy-profit-and-loss-for-powerbi/#comment-719 is the best alternative in my eyes. No need to read on 🙂 As (…) Read more
Custom Connector to import Google Sheets with OAuth2 authentication in PowerBI
EDIT 17th Feb 2022: Finally, we have the native connector in Power BI: Power Query Google Sheets connector – Power Query | Microsoft Docs – so no need for the (…) Read more
How to create and use an R-function-library in Power BI
Edit 10-10-2017: There is also a (simpler) way to run a custom function library described here: http://www.thebiccountant.com/2017/10/06/create-a-function-library-in-power-bi-using-m-extensions/ . If you go that route, the only point of interest in the (…) Read more
Tips and Tricks for R scripts in the query editor in Power BI
Especially if you are new to R, there are some things one needs to know to successfully run R-scripts in the query editor of Power BI. I will share them (…) Read more
How to import from Excel with cell coordinates in Power Query and Power BI
There might be occasions where you want to import data from Excel into Power Query or Power BI using cell coordinates like a range from E3 until G9 for example (…) Read more