Forum Discussion

rodneyc8063's avatar
rodneyc8063
Advocate I
2 years ago

Report using SQL - Unable to edit under applied steps settings?

Howdy folks,   My team is new to PBI and I am trying to help out a co worker with trouble shooting a PBI report hes working on currently and I had a few questions I was hoping for some help on.   ...
Need Help
rodneyc8063's avatar
rodneyc8063
Advocate I
2 years ago

Appreciate the quick reply

 

Follow up question please for the greyed out "Settings" option under Applied steps.

 

...or blank query that includes text value etc.. in your SQL side.

For example:

"

let

in

Source = Sql. Database(SQLServerName, DBName, [Query="select * from ["&#"BlankQueryText"&"]"

Source

"

Sorry what do you mean by "blank query that includes text value"?

 

I admit I am not familiar with M language so cant quite figure out what this section means/does? -> "select * from ["&#"BlankQueryText"&"]"

 

 

gokberkuzuntas's avatar
gokberkuzuntas
Regular Visitor
2 years ago

For example you can create blank query in Power Query(Transform Data) side that you can give value(Picture 1.1). So the value from Query3 is assume that your database name and when you use in your M language code Query3 value is fetched to your code.

Original M code:

Source = Sql. Database(SQLServerName, DBName, [Query="select * from ["&#"Query3"&"]"

 

The fetched hidden code will be like: 

Source = Sql. Database(SQLServerName, DBName, [Query="select * from [data]"

 

Picture 1.1

 The important thing is do you have such as ["&#"BlankQueryText"&"]" in your Prior Fiscal Year table(SQL query). Because I couldn't see your whole sql code. İf you have like such M code ["&#"BlankQueryText"&"]  that's why you can't see grey icon.

 

Best Regards,
gokberkuzuntas

LinkedIn: https://www.linkedin.com/in/g%C3%B6kberk-uzunta%C5%9F-b43906198/

Medium: https://medium.com/@uzuntasgokberk

 

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