Workday Integration file (Web) into Power BI

[mmills2018]

Hi All,

I am trying to get data from the web (workday integration file) into my power pi desktop.  I keep getting the below error:

Unable to connect.  "we encountred an error while trying to connect. Details: The operation has timed out"

i have tried the advanced option and set the command timeout in minutues, but I still can't get my data to load from the web.  

any ideas why?

[v-rzhou-msft]

Hi @mmills2018 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,

Rico Zhou

[mmills2018]

unfortunately it was not solved and i had to take another route of getting my data in power bi

[mmills2018]

would it be an issue with my URL? you wouldnt have access to the URL that I would share...

[themistoklis]

Is it a public URL or a URL where you need to add credentials?

[mmills2018]

it is not a public URL

[v-rzhou-msft]

Hi @mmills2018 

Try to add timeout setting advance editor in Power Query.

You may refer to this blog for more details: Query Timeout on update

Best Regards,

Rico Zhou

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

[mmills2018]

i did extend the time out time when i am getting the data through the web option.  it was able to connect and i know get this error, any ideas?

[v-rzhou-msft]

Hi @mmills2018 

Your error shows that something in your source doesn't exist.

Is DHR_... or a value, a column or a table in your data source?

Did you remove something in your datasource?

It seems that your datasource is not public.

Have you add your username and passwords into your query when you got data from power query?

For more details: Blog

In data source setting, please remove the existing connection for web and try one more time.
You can also set the permission level while editing the data source.

Best Regards,

Rico Zhou

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

[themistoklis]

Hello @mmills2018 

Can you share the URL you are trying to connect to?