Forum Discussion
Using Excel Connector with PBI Datamodel
Hi Guys I'm working with a client who basically wants to create a set of data that can be consumed through Excel, so I've recommened that they can use PBI to build out a datamodel and then use th...
Flipper ,Based on what I got.
In case table on the one side have less values say have 5 category and fact(many side table) has 6.
You will get one blank row with all measures created from fact when they are used with category.
By default is it right join. +0 can force left also.
In case you want to remove the blank of one side when value is missing ;you need to use a visual or page level filter for that