Forum Discussion

larryneal's avatar
larryneal
Frequent Visitor
6 years ago

Data Gateway - Import and Direct Query Workspaces

I have two reports that have been published to the service. 

1) Invoice Report (using Direct Query)

2) Time Report (using Import)

 

These reports are published to two different workspaces. 

They both use the same database. A data gateway has been established is showing online and running within the service. 

 

The invoice report loads with refreshed data without any problems. The time report does not update. 

I have reviewed serveral post and tried to find the appropriate refresh options within the service for the dataset. The only options I see are related to cache refreshes not the actual import refresh. 

 

So, I guess my question, can you mix and match query types with the same data gateway?

 

Thanks in advance, 

Larry

 

Need Help

11 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    6 years ago
    Hi there

    You certainly can from your screenshot the dataset called TimeReview2 is using DirectQuery or LiveConnection because it has not go the option for scheduled refresh?
    • larryneal's avatar
      larryneal
      Frequent Visitor
      6 years ago

      GilbertQ 

      The TimeReview2 dataset is for the time report, this is the dataset that is not updating and the report is configured with import method. 

    • larryneal's avatar
      larryneal
      Frequent Visitor
      6 years ago

      v-lionel-msft 

      I have reviewed this document several times. I have the refresh configured on both datasets yet the import set still does not update. 

      Below are several screenshots from both datasets and their corresponding refresh settings. I've also included a screen shot of the history which shows that the process appears to be completing as expected. 

       

      Refresh Settings -- Direct QueryRefresh Settings -- Import

       

      Cache refresh history

      • v-lionel-msft's avatar
        v-lionel-msft
        Community Support
        6 years ago

        Hi larryneal ,

         

        Are you sure your Time report using import mode? If it's import mode, you can only use "Scheduled refresh" instead of "Scheduled cache refresh".

        --Import mode

         

        Maybe you use the same connection mode for the same data source, so the gateway only updates a connection.

         

        Best regards,
        Lionel Chen

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.