Forum Discussion
Using an html query in Power BI Desktop?
Someone sent me an html query that they indicated was used to extract info from a SharePoint site into Power BI. It starts like:
let
Source = TicketTrackingSystemCurrent,
#"Reordered Columns" = Table.ReorderColumns(Source,
{"Id",
"BusinessUnitValue",
"SalesOrderNumber",
And continue for a few hundred lines.
I'm still a PBI "noob" and though I've done many queries have no idea how to enter this into a Desktop query. I've doe a lot of Googling to no avail.
Can this be entered into a query? If so, whee and how?
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
4 Replies
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
