Accessing Power BI confidential data in Excel for internal organization users
Perficient Digital Transformation
SEPTEMBER 6, 2022
Apart from that, users also heavily use hyperlink to another Excel files reusing existing source data already prepared by other people. A dataset is essentially a collection of tables co-related using the relationship feature of Power BI. One needs to use VLOOKUP, XLOOKUP, MATCH, INDEX like functions for co-relating data.
Let's personalize your content