Forum Discussion

BIXL's avatar
BIXL
Icon for Resolver I rankResolver I
10 years ago
Solved

unable to scheduale refresh to on premise SQL

  Hi All, I have a Power  BI Desktop model uploaded to PowerBI.com. The model has data source from on premises xls files and on premises SQL DB. I configured a personal gate way, and signed up fo...
  • BIXL's avatar
    BIXL
    10 years ago

    It seems that using my own parameter configuration (as described above) does not work for schedualing refresh.

    I replaced the connection parameters with the new build in functionality in query editor and now it works fine.

BIXL's avatar
BIXL
Icon for Resolver I rankResolver I
10 years ago

Hi dimazaid,

My connections in pbix file are arranged as followed :

1. have a local table in the model CONNEX_PARAMS : Table.FromRows(Json.Document)... that has the following :

ServerDB_NameFiles_Location
<My Server><SQL DB NAME>f:\powerbi\

 

2. all other tables are using this parameter table instade of hard coded. 

for example for files :

Files_Location=CONNEX_PARAMS{0}[Files_Location],
File_Name="FILE1.xls",
File_Full_Path= Files_Location & File_Name,
Source = Excel.Workbook(File.Contents(File_Full_Path), null, true)

 

for example for SQL tables :

Server=CONNEX_PARAMS{0}[Server],
DB_Name=CONNEX_PARAMS{0}[DB_Name],
Source = Sql.Database(Server, DB_Name)

 

 

thanks

BIXL's avatar
BIXL
Icon for Resolver I rankResolver I
10 years ago

It seems that using my own parameter configuration (as described above) does not work for schedualing refresh.

I replaced the connection parameters with the new build in functionality in query editor and now it works fine.