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
anithat's avatar
anithat
Icon for Resolver II rankResolver II
10 years ago

Hi aspardo

 

In the Advanced query options write the query in the format that your database accepts. No need to modify it as per the powerBI format.

 

In general, You might be using some third party tool to execute your queries and check the data. Use the same query in same format - just COPY and PASTE that query in power BI desktop Advanced query options.

 

PowerBI converts it into its readable format.

 

Further, at any point if you want to change the query, then

 

1> Go to Edit Queries

2> Choose the query

3> On the right hand side Double click the 'Source' under Applied Steps

4> Modify the query

5> Save

 

If you have any further issues, please let me know.

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

Hi anithat Curious to know how this works? I'm facing a similar issue. I have built a query in mysql client and want to copy paste this. My questions are:

1) First I have to connect to source and load tables? or

2) Write the query in advanced editor and then connect to source? Confused how it works.