Forum Discussion
Using an html query in Power BI Desktop?
Your screenshot looks like it's from the query editor/advanced editor.
Click Edit Queries
Then either
Click Advanced Editor and put your code there
Create a blank query and then Click Advanced Editor
Um, thanks but the answer bears no relation to my question. Making OData and other connections to SharePoint is easy, but I received an advanced query written in html from someone that pulls data from different locations and combines it. I am trying to figure out how this is used or imported into PBI.
Your screenshot looks like it's from the query editor/advanced editor.
Click Edit Queries
Then either
Click Advanced Editor and put your code there
Create a blank query and then Click Advanced Editor
Yes, you are correct. Shortly after my last reply I figured out how to enter it using the Advanced Editor (as you show).
Unfortunately the query I was sent is riddled with errors so it's not working, but that's nothing that this group can help with. :-)