PowerBI offers some great native and custom visuals that integrate and interact almost perfect together.

But many times we need a visual that either doesn’t exist or doesn’t offer the functionality we want. There are great examples of R visuals with code online ( R community is also great )…


PowerBI desktop September update has added the functionality of custom ( pages ) tooltips also to card visual.

This adds another great option for us to help users with instructions, explanations, calculations & more.

My opinion is to always add instructions or explanations, remarks on a report. This is super…


We will create a custom connector in Flow that refreshes any dataset in PowerBI you want and you can use it with any other connector.

Bonus, we can use it for calling other PowerBI API actions as well.

I was trying to find a way to refresh a PowerBI dataset…


PowerQuery Dynamic Date Dimension Table Filtering

in Power BI Desktop , PowerQuery Excel

I really like the new CALENDAR() function in DAX and the ability to create a dynamic Date table. …


How to import data in PowerBI Desktop stored in OneDrive Business, upload in #PowerBI service and schedule refresh ( valid as of end of August 2015 )

PowerBI service & OneDrive for Business are really working great together and as long as we have an O365 subscription we can use…


PowerBI Designer files can refresh the data model & visuals if stored in OneDrive business or Personal

Updated 25/7/2015 After the GA of Power BI Service refreshing PowerBI Desktop is supported and well documented in support.powerbi.com

After the latest updates in Microsoft PowerBI Preview which now enables you to refresh…


Use Power Query to check if text fields are Proper, Capital, Lower & more

I come up with a situation where I need to check some text fields like ‘Name’ regarding the Quality of data entry in a PowerBI data model. Specific I needed to see if the Name was…


I was reading Avidal’s post regarding querying tables with DAX and transform them from flat tables to star schema data models. Is true that DAX works better with star schema modelling.

Many times I am in the need to combine totally different data sources and need and create a dimension/lookup…


We are going to show how to change a Measure in PowerPivot Table based on a cell value. This will include some simple VBA and linked tables.

I always use the technique from Rob Collie to change a measure with disconnected slicers but sometimes the user needs to enter a…

Konstantinos Ioannou

Microsoft Power BI Consultant || Business Data & Visualization Expert http://gr.linkedin.com/in/konstantinosioannou/

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store