Forum Discussion

pgerula's avatar
pgerula
Frequent Visitor
9 years ago

Can't refresh data after appending queries - PowerBIGateway 14.16.64.64.1

After instalation of PowerBIGateway 14.16.64.64.1 I can't set data gateway (on-premises gateway) if report contain append queries.   It is possible to set data gateway settings to personal mode but...
pgerula's avatar
pgerula
Frequent Visitor
9 years ago

Hi Lydia,

I tested your suggestion and it works, but it is not acceptable for many files used at gateway.

 

Can you tell me when this situation will be fixed?

 

Best Regards,

Pawel

Anonymous's avatar
Anonymous
Not applicable
9 years ago

pgerula,

The team is fixing this issue, once the issue is fixed, I will post back.

Regards,
Lydia

  • jason435's avatar
    jason435
    Icon for Helper II rankHelper II
    8 years ago

    Are people having the same issue with ODBC sources? I see most people are having issues with folders of CSV files and appending. I have two ODBC databases (5 tables each). I can refresh without apending, after apending just two table with each other no.

     

    Any update from MS on new gateway?

  • bjnodello's avatar
    bjnodello
    Icon for Helper II rankHelper II
    8 years ago

    Hello Anonymous, any updates on this one?  Issue stills seems to exist.

     

    Thanks,

     

    Brett

  • Dimitar's avatar
    Dimitar
    Frequent Visitor
    8 years ago

    Hi Brett, we realised two weeks ago that the problem resolved by itself ... without any change from our side...So now we are able to refresh again.

    Good luck to you!

    Dimitar

  • pgerula's avatar
    pgerula
    Frequent Visitor
    8 years ago

    Good to hear that.

    Thank you,

    Pawel

  • bjnodello's avatar
    bjnodello
    Icon for Helper II rankHelper II
    8 years ago

    Interesting, no luck for me.  I'll need to check what version we are running.

     

    Thanks,

     

    Brett

  • bjnodello's avatar
    bjnodello
    Icon for Helper II rankHelper II
    8 years ago

    We are on 14.16.6650.1 and the issue still exists for me.  I have two reports with exactly the same data sources.  The only difference is that in 1 report I append 2 queries together and in the other I leave them as seperate.  For the report with appended queries I get the following warning in the section for scheduling a refresh: "You don't have any gateway installed or configured for the data sources in this dataset. Please install a new data gateway, or configure the data source for an existing data gateway."