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
newpi's avatar
newpi
Icon for Helper V rankHelper V
6 years ago

alwweb Doing the same steps and when I click ok. I get the error of no database selected.
 Whereas If I run without this query, I'm able to connect to the data from the pop up and selecting raw tables.

alwweb's avatar
alwweb
Icon for Advocate II rankAdvocate II
6 years ago

newpi  - my default database name is part of my DSN definition on a page with an option to change the default database. 

 

If your databasename can't be defined in the DSN, is there a way to set it in the connection string above the SQL statement by using the database= option? 

  • newpi's avatar
    newpi
    Icon for Helper V rankHelper V
    6 years ago

    This is now solved. The 4 missing columns data was loading as Binary and I converted it to text type in the query editor and could load all columns

  • alwweb's avatar
    alwweb
    Icon for Advocate II rankAdvocate II
    6 years ago

    newpi  So glad you figured that out.  I was not even considering that as one of the troubleshooting steps I was trying to put together for you.  

  • newpi's avatar
    newpi
    Icon for Helper V rankHelper V
    6 years ago

    alwweb Thanks. Just solved this. I just had to modify my query. In MYSQL client I was just writing and doing a select * from table name and that was working fine there but in power bi I had to do Select * from database.tablename and it worked.

    Also, but I'm facing another issue here. I have close 8 columns in my output but in the power bi after connecting with SQL optional statement I'm only seeing first 4 columns and missing the others. This query has multiple left joins so I don't know if that is the issue.

    Power BI Columns

     

    All columns in MYSQL client