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
Helper 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

newpi's avatar
newpi
Helper 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
    Advocate 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.