Adani Enterprises Senior Data Analyst Interview Questions and Answers

Data sources in Power BI can be connected through various methods including importing data from files, databases, online services, and streaming datasets.

• Import data from files such as Excel, CSV, XML, JSON, etc.

• Connect to databases like SQL Server, MySQL, Oracle, etc.

• Utilize online services connectors for platforms like Google Analytics, Salesforce, Facebook, etc.

• Set up streaming datasets for real-time data analysis.

To add a file from SharePoint, you can use the SharePoint API or sync the SharePoint library with your local machine.

• Access the SharePoint site and navigate to the library where you want to add the file.

• Click on the 'Upload' button and select the file you want to upload.

• Alternatively, you can sync the SharePoint library with your local machine using OneDrive or SharePoint Sync.

• Once synced, you can simply drag and drop ...read more