Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Cannot schedule refresh with appending query

Hi everyone, 

I am having a wierd issue in PBI Cloud with one of our PBIX reports where I cannot set up the refresh schedule if I choose to append one of the queries within my PBIX. 

 

My PBIX loads data from two sources, CSV file (Local) and a web page data (Web) (http://api.aip.com.au/public/api?call=tgpTables). I've establish both of these as gateway entries wtihin PBI Cloud. WebJSON ans Local are names of the queries with PBIX, that loads data from the web source and local CSV source, respectively. If I choose not to append these two queries, I am able to set this report to refresh automatically. But, if I choose to append them, Gateway goes crazy and the bit within Gateway connection, the wheels keep spinning looking for the gateway. 

 

Any idea what's going on here? 

 

Thanks

Kaz

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Anonymous It sounds like you are trying to merge online and local in an (Enterprise) gateway. This doesn't work currently. You can't use online and on-premises in the same connection. Now, it sounds like you don't have issues with them in the same report until you append them... which is new to me. I would have thought it would fail regardless, if I understand your question correctly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Anonymous

       

      That's confusing me as well. I would have expected it to not to work at all. But it's just the appending bit that pushes PBI Gateway over the edge.