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
Hi Anonymous
It seems you may have a look at below post.It shows how to get the data from SharePoint in Power BI
https://community.powerbi.com/t5/Service/Power-BI-Get-Data-From-SharePoint-List-Library/td-p/280109
Regards,
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. :-)