Refresh Scheduling

I have a Power Bi Report on desktop that when I press refresh it refreshes fine, but I have to do it mannualy every day. I have tried using the web app and the shedule refresh is disabled and I can`t find a workaroun so it refresches daily.

The procees to extraxt the data is to first get the token from a Basic Login (username and paswword) and the output is on json format like this:

{
"Messages": [
{
"Type": "System",
"Level": "Info",
"Message": "Success"
}
],
"Data": {
"SiteId": 1,
"CompanyId": 40,
"TenantCode": "VIV",
"Company": "Vivaaerobus",
"UserId": 10088,
"DisplayName": "vESB Middleware VIV PRD",
"UserName": null,
"Email": "[email protected]",
"Token": "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"TokenScheme": "vToken",
"DateValid": "2025-01-30T14:49:07.3656981+00:00"

From that Json output I need to extract the Token and on this adress create anothe GET API Call:

https://viv.i-soms.com/vesb/api/public/vpos/Report/monthlySalesExt/:DATE

and on the Headers include the Authorization: vToken & (token)

The Date is a parameter and should be YYYY-MM-DD
The output is a CSV Report of the oparatin of that day so I need to do this daily.


This is my power query code that works fine only on desktop side:

Function (Login2) :

() =>
let
body = [username="[email protected]",password="xxxxxxx"],
Source = Web.Contents("https://viv.i-soms.com/vesb/api/ac/sec/account/login",
[

Headers=[#"Content-Type"="application/json"]
]),
// Convierte el contenido JSON de la respuesta
JsonContent = Json.Document(Source),
// Extrae el token del campo 'Token' dentro de 'Data'
Token = JsonContent[Data][Token]
in
Token

And then another function called (Monthly):

let

let
// Define the start and end dates
DateStart = Date.From(RangeStart),
DateEnd = Date.From(DateTime.FixedLocalNow()),


// Generate a list of dates between the RangeStart and RangeEnd
dateList = List.Dates(DateStart, Duration.Days(DateEnd - DateStart), #duration(1, 0, 0, 0)),

// Function to retrieve data for a single date
GetDataForDate = (Fecha as date) =>
let
searchText = Date.ToText(Fecha, "yyyy-MM-dd"),

url = "https://viv.i-soms.com/vesb/api/public/vpos/Report/monthlySalesExt/",
csvContent = Web.Contents(url, [Headers=[Authorization="vToken " & Login2()],RelativePath = searchText]),

// Convert the CSV content to a table
csvTable = Csv.Document(csvContent, [Delimiter=",", Columns=53, Encoding=1252, QuoteStyle=QuoteStyle.None]),

// Promote the first row to headers
promotedHeaders = Table.PromoteHeaders(csvTable, [PromoteAllScalars=true]),

I works fine only on desktop, I have tried a Destop Custom connector and a web one on power automate but I havent been succesfull on both tries, could any one help me I would appreciate it very much..