Forum Discussion

cecyarmida's avatar
cecyarmida
Frequent Visitor
7 years ago

Dataset refresh has stopped working with different errors each time I try to refresh

Hi all, On Friday I relased a new version of my data set and Saturday and Sunday it refreshed correctly. But it failed on Monday morning, my dataset connects to an Azure Function Proxy.  I can still...
Need Help
cecyarmida's avatar
cecyarmida
Frequent Visitor
7 years ago

Thank you Dale,

Today I got a different error, on my chages I added a List.Contains from a biffered List:

 

Message: [Unable to combine data] Section1/Job/AutoRemovedColumns1 references other queries or steps, so it may not directly access a data source. Please rebuild this data combination. Table: Job.
Cluster URI: WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net
Activity ID: dc3f443d-633b-408b-baaa-1cdfd5d3ca1b
Request ID: 147d4c30-b820-4116-8683-af5c0673e697

 

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

Hi cecyarmida,

 

1. Did you use the Data Gateway (personal mode)? I would suggest you try the Data Gateway (the other one).

2. What does the table JOB look like? Is it a normal table from a data source?

3. I also found many error messages like "the gateway is unreachable". Please check out.

 

Best Regards,

Dale

  • cecyarmida's avatar
    cecyarmida
    Frequent Visitor
    7 years ago

    Hi Dale,

    I am not using a data gateway, I am only connecting to an Azure Functions Proxy that connects to WorkflowMax API:

     

    https://blog.kloud.com.au/2018/07/23/use-anonymous-authentication-on-web-data-sources-with-a-api-key-in-url/

     

    At the point I wrote the blog everything was working fine, then I added the following changes to my data set:

    1. I have a base data set that gets all the data from WorkflowMax/Proxy, so I created a new table based on this data set to get territory.

    2. Then on the Job table I am doing a filtering on a column by using List.Contains from a Buffered List (To validate is an existing territory).  I basically load the territories on a buffered list to do the comparison, the territory list is not to big it has like 15 fields

     

    So I don't know where the gateway error is coming from.

     

    Many thanks

     

     

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

      Hi cecyarmida,

       

      Can you refresh it successfully in the Desktop? Can you share the Power Query code? Please mask the sensitive parts first.

       

      Best Regards,

      Dale

      • cecyarmida's avatar
        cecyarmida
        Frequent Visitor
        7 years ago

        Hi Dale,

        After installing the new version of Power Bi Desktop it started to fail on my local machine as well.  Now I can't even refresh it with out my laptop crashing.  I reinstall my office to a 64b, and still the same.  Can I send you the Frown file to any email? I don't want to publish all my code here.

         

        Thanks