Forum Discussion

icassiem's avatar
icassiem
Post Prodigy
2 years ago

How to Refresh HTML file with Javascript embeded and result loaded as web source

Good day,   After several attempts of executting a specific javascript within PQ web.page So i decided to save the HTML that contains the javascript that generates the signed certificate to a cent...
Need Help
icassiem's avatar
icassiem
Post Prodigy
2 years ago

Thank You Anonymous 

 

Point1

I have tried a few things and below i return an text result BUT not the expected text value, it completely differs from what the HTML is is displaying, the starting char are always "ey.." but this starts "W3sf.."

let Source = Web.Page(File.Contents("file:///C:/Temp/test2.html")),

// Source = Web.Page(Web.Contents("file:///C:/Temp/test2.html"))
// Source2 = Json.FromValue(Web.Contents(Source))
Source2 = Json.FromValue(Source),
// Source2 = Json.Document(Source),
Source3 = Binary.ToText(Source2)
in Source3

 

Point2

I have previously tried using PBI REST API that required app reg on Azure using the token but could never get it working for PBI Usage Matrix report, i have admin access to a test azure , do i need to register the api app again?

Kindly provide examples on how to ahcieve this and how to be used to refresh the HTML Javascript file please?

 

Regards

icassiem's avatar
icassiem
Post Prodigy
2 years ago

Hi,

Another lost cause, i just cant get this javascript S256 ssassign KUR to generate secret

 

The HTML Web Table does not work due to the resul being javascipt generated result and only works when Table in HTML Source

"Power Query does not recognize HTML tables with just one row"

"This method works only if the table is available in the page source and doesn't require JavaScript to render it."

 

Have run out of options, is there a way of using powershell/dataverse or something in PBI to help me refresh the javascript but is allowed a a data source refresh within PBI Service

?