Using an html query in Power BI Desktop?

[Daryl_K]

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?

[v-cherch-msft]

Hi @Daryl_K 

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,

[Daryl_K]

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.

[Aron_Moore · Accepted solution]

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

[Daryl_K]

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. 🙂