Forum Discussion

ShafiqRuslan's avatar
ShafiqRuslan
Helper I
7 years ago
Solved

Schedule Refresh - Automatically Gateway is Selected

Hi all,   I have a report with several data sources (data warehouse, database, Sharepoint, etc.) but I can't set up schedule refresh. The error message that prompts up is    The keyword isn't...
Need Help
Show and Tell
Tutorial Requests
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi ShafiqRuslan,

     

    I would suggest you create a support ticket here. I'm afraid it's hard to troubleshoot in the forum.

    create ATicket

     

    Best Regards,
    Dale

ShafiqRuslan's avatar
ShafiqRuslan
Helper I
7 years ago

Last refresh failed: Wed Sep 26 2018 00:25:01 GMT+0800 (Malaysia Time) 
There was an error when processing the data in the dataset.

 

Message:The keyword isn't supported: version. Parameter name: keyword Table: agentlogging.
Cluster URI:WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net
Activity ID:63a5289e-5e96-422f-83a3-8de3f49a40d7
Request ID:ee137db0-cf4d-477e-adfe-faaa97d9e706
Time:2018-09-25 16:25:01Z

 

Here's the full error message. I do have the latest version of PowerBI and the two tables are not special I reckon

ShafiqRuslan's avatar
ShafiqRuslan
Helper I
7 years ago
Just to add some comments on the below, I'm not sure how this works;
 
What we're trying to achieve is for the reports to have a scheduled refresh without having the need for a gateway (because we do not have a dedicated pc for this). We've managed to do this for one of our other dashboards in which the data source is in my company's Azure cloud.
 
The new dashboard that we have, data does not reside in our Azure cloud. Is this the reason why a gateway is automatically selected?
  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    Hi ShafiqRuslan,

     

    So where is it as the data doesn't reside in your Azure cloud? BTW, I'm still digging into the logs.

     

    Best Regards,
    Dale

    • ShafiqRuslan's avatar
      ShafiqRuslan
      Helper I
      7 years ago

      It's our vendor's data, I'm not sure where it resides but I think it's on their cloud

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee
        7 years ago

        Hi ShafiqRuslan,

         

        I just found the log keep saying "ProcessDatabaseFailedOnPremiseErrorException". 

        1. Seems it's an on-premises SSAS server. How do you connect it?

        2. Can you refresh it in Desktop successfully?

        3. How about the Gateway (enterprise mode)?

        4. Did you found something helpful in the link of my last post?

         

         

         

        Best Regards,
        Dale