Q 1. You loaded data to your Power BI desktop from a Microsoft Access database file (file.accdb) which is around 20 MB in size. However, when the data was loaded and copied into a power bi desktop file (file.pibx) the size of this file was observed to be around 3 MB in size. What could be the possible reason for this noticeable reduction in size?
Q 2. In Power BI Query editor, what do you do to translate the currently selected columns into attribute-value pairs, combined with the rest of the values in each row in an organized manner?
Q 3. You have a business tool built over Power BI and all the customers using the tool has the same database schema. However, the databases have different names and are hosted in different instances of SQL Server. How can you connect to different databases just using one query?