Setting a refresh schedule - please help me

Dor1411993 · ‎02-22-2022

Hello evreyone!I'm sorry if it is a simple question, but I've been tangled with this problem for a very long time, and I really need help.I have files in my onedrive folder, and I use them in the powerBI Dashboards.I obviously want them to be refreshed by schedule, therefore I set the gateway as I saw in a few videos, and I seem to be connected properly:

THe problem is that on the dataset setting, I have this Error:

without any option to schedule.

As far as I could understand and dig,
I need to change the data source settings from the desktop in Advanced Editor,
Right?

If so, What I need to change in the csv file:

let
Source = Csv.Document(File.Contents("C:\Users\User\OneDrive\PowerBI\Demo Model\files\FME_rvt.csv"),[Delimiter=",", Columns=6, Encoding=65001, QuoteStyle=QuoteStyle.None]),
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"ObjectId", Int64.Type}, {"BuildingLevel", type text}, {"Family", type text}, {"FamilyType", type text}, {"Error", type text}, {"count", Int64.Type}})
in
#"Changed Type"

in the Excel file:

let
Source = Excel.Workbook(File.Contents("C:\Users\User\OneDrive\PowerBI\Demo Model\files\transormer.xlsx"), null, true),
Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(Sheet1_Sheet, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"GlobalId", type text}, {"Tag", Int64.Type}})
in
#"Changed Type"

And in the db files (sqlite3)

"""C:\Users\User\OneDrive\PowerBI\Demo Model\files\FME_rvt3.db""" meta [IsParameterQuery=true, Type="Text", IsParameterQueryRequired=true]

Thank you very much!

Dor