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 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

  • 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.

4 Replies

  • samdthompson's avatar
    samdthompson
    Icon for Memorable Member rankMemorable Member
    10 years ago

    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's avatar
      dimazaid
      Icon for Microsoft Employee rankMicrosoft Employee
      10 years ago

      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 [email protected] and we can take a look.

      • 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