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

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

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

      Hi cecyarmida,

       

      Maybe you can upload your file to the cloud drive and send the link to me through Messages. I will try to find out the cause.

       

       

      Best Regards,
      Dale

      • cecyarmida's avatar
        cecyarmida
        Frequent Visitor
        7 years ago

        Hi Dale,

        After I trying many different things, I installed a previous version(April) of Power BI Desktop and refreshed my dataset and everything worked fine.  But still, once I publish it to the Power Bi service it fails, I have spent so much time on this, so I think I am just goint to wait for the next version, hopefully this issue will be fixed.

         

        Thanks for your help,