Forum Discussion

powerbi_ohio's avatar
powerbi_ohio
New Member
2 years ago
Solved

PowerBI Import Issues

I have an existing query that I need to pull into PowerBI.  The query runs in dBeaver, SAS EG, Toad but when I paste the query into the SQL Statement under Advanced Options when I 'Get Data' it provi...
Need Help
  • powerbi_ohio's avatar
    powerbi_ohio
    2 years ago

    Thanks for your help but I figured out a solution.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi powerbi_ohio ,

 

Based on the descriptive information you provided, the issue appears to be related to the date time field. In Power BI, you need to use a specific date format for the literal amount. Make sure your date literals are in a format like "YYYY-MM-DD HH:mm:ss" so that Power BI recognizes them.

 

Try to modify your formula like below:

FROM db.census
LEFT JOIN db.enroll ON
    census.id = enroll.id
    AND census.term = enroll.term
    AND enroll.date = '2024-01-29 00:00:37'

WHERE (census.start_dt IS NULL 
    OR census.leave_dt >= '2024-01-22 00:00:00')
    AND census.include_flag = 'Y'

 

Best Regards,
Adamk Kong

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

powerbi_ohio's avatar
powerbi_ohio
New Member
2 years ago

I can't even get the raw data into PowerBI.  I'm using the SQL Statement dialogue box under advanced options.  The query that I have works in dBeaver, SAS and Toad, but when inserted into the SQL Statement dialogue box in PowerBI is when the error is triggered when trying to import.