හවුල් ශ්‍රව්‍ය

Teacher: We just learned how to bring in data from files. But tell me, do you think all company data is stored in Excel files? Learner: Probably not. I think bigger companies use databases, right? Teacher: Exactly! Many organizations use relational databases like SQL Server, Oracle, MySQL, or Azu…

Teacher: We just learned how to bring in data from files. But tell me, do you think all company data is stored in Excel files? Learner: Probably not. I think bigger companies use databases, right? Teacher: Exactly! Many organizations use relational databases like SQL Server, Oracle, MySQL, or Azure SQL Database. Learner: And Power BI can connect to those directly? Teacher: Yes. In Power BI Desktop, when you click Get Data, you’ll see options like SQL Server Database or Oracle Database. You j