unable to scheduale refresh to on premise SQL

[BIXL]

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 for the pro account.

when I am trying to scheduale a refresh of the dataset I get an error :

"You can't schedule refresh for this dataset because one or more sources currently don't support refresh"

Thanks

[samdthompson]

This happened to me too. Turned out that the organisational firewall didn't like the personal gateway. have a chat with IT about getting it opened up.

[dimazaid]

@BIXL 
This looks to be an error with your connection string/ one or the your Mashup text. Could you explain what you're trying to do? if you'd like to share it offline, send me an email to dimazaid@microsoft.com and we can take a look.

[BIXL]

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 :

Server	DB_Name	Files_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 · Accepted solution]

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.