Would love to see a video on best practices when working with multiple flat file excel sheets as the data sources with the same row cardinality but different column dimensions. Do you merge into one flat file then build the star schema? Do you setup a fact table of just the cardinality rows then join each dimension table to it, removing redundant columns? What about if you need to do a lot of cross table calculations and filtering, is it worth it to do flat in that case instead?
Hi Adam, another way of hiding the column header is to just completely replace it with space on your keyboard. I use that technique and it works 👍.
Space won't work, but a white space would (mongolian vowel separator in unichar).
@@amigomusa Space is not allowed. In windows, open Character Map and search 200C. Copy that character and replace the column name in PowerBI.
Every time I watch one of your videos, I learn something new and am motivated. Thank you. 🙏🏻
Love the idea of this and making it more personable to the team!
Would love to see a video on best practices when working with multiple flat file excel sheets as the data sources with the same row cardinality but different column dimensions. Do you merge into one flat file then build the star schema? Do you setup a fact table of just the cardinality rows then join each dimension table to it, removing redundant columns? What about if you need to do a lot of cross table calculations and filtering, is it worth it to do flat in that case instead?
Hi Adam, can i controll whether the tooltip Appears of not, depends on the datapoint?
How can I get the data files to work on it?
Inserting an image through a table visual - I guess only Microsoft is capable of such perversions!
Guys can you please make video on incremental refresh get latest data in real time with direct query option premium only and its disadvantages
Hi Adam and Patrick,
when we are going to see REGEXTEST, REGEXEXTRACT, and REGEXREPLACE. these in power bi Dax???