Forum Discussion

aspardo's avatar
aspardo
Regular Visitor
10 years ago

New to BI. Writing SQL queries to parse data. I am obviously missing something.

Started using Power BI on the recommendation of a friend. It looks well made and powerful, so I hope to stick with it.   I am pretty decent with SQL and can write some lengthy queries. My goal is t...
Need Help
aspardo's avatar
aspardo
Regular Visitor
10 years ago

Thank you for these detailed responses. I really do appreciate it.

 

1) I put the database credentials into the the screenshotted area that you linked. I write the query into the SQL statement area, but not in regular SQ, but Power Query Formula Language?

2) Once that information is pulled into BI I am unable to change the query structure and get new data and I have to start the process over? In other words, I get to put the query in once and go with that.

3) I assume the query can link multiple tables together? Such as SELECT * FROM customers LEFT JOIN account.customer_id_=customers.id WHERE customers. id > 1000

4) KHorseman mentioned that BI can handle a lot of query operations. What potential benefits are there in using the buttons instead of writing the query and getting the exact data I need?

arify's avatar
arify
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago
  1. Credentials will be entered in the next dialog, not the one in my screenshot. Yes, it'll be regular SQL.
  2. Yes
  3. Yes
  4. UI buttons are just an easier way of doing things, if you prefer writing your own SQL it's also fine :)