Help

Jamf Powerbi Connector Timeout

cleverleys
Contributor

Posted on ‎08-11-2022 04:44 AM

Hi everyone, 

Has anyone had success with using the Powerbi Connector?  I've managed to pull all data in, created a couple of small dashboards, but it never seems to refresh.  Even a manual or scheduled refresh ends up timing out after a few hours.

I've also shrunk the data set to one table, and removed some of the unwanted columns.

Any thoughts or suggestions would be grateful received!

 

0 Kudos
6 REPLIES 6

dthreewitt
New Contributor II

Posted on ‎08-11-2022 11:19 AM

I've been using PowerBI for a while, and my reports(dashboards) are timing out now too. Never had an issue until this week(I was out of town last week, so I don't know when it actually started).

cleverleys
Contributor
In response to dthreewitt

Posted on ‎08-11-2022 04:00 PM

Ah, so it could be a Microsoft issue then.

I keep getting the attached error now, even though I’ve reduced the data set!

74810802-CC42-4F70-90E5-51CF174BBE9F.jpeg

0 Kudos

dthreewitt
New Contributor II
In response to cleverleys

Posted on ‎08-12-2022 06:13 AM

I just went to refresh the data on my reports so I could screenshot my error. Yesterday I was getting 502 bad gateway errors when it got to data for different objects (Computer 152, Device 98, etc). Today everything refreshed smoothly. We were also having issues with 502 errors enrolling wiped macbooks, hopefully those are gone now too...

0 Kudos

dthreewitt
New Contributor II
In response to dthreewitt

Posted on ‎08-17-2022 09:02 AM

I apparently spoke too soon. Now I've got the error back. It worked great for a couple of days....

OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://<jamfcloudserver>/JSSResource/computergroups/id/13' (502): Bad Gateway.

And in a different query 

OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://<jamfcloudserver>/JSSResource/mobiledevicegroups/id/10' (502): Bad Gateway.

0 Kudos

Ericbolen
New Contributor

‎08-16-2022 11:42 PM - edited ‎08-17-2022 09:11 PM

I am having a same problem with I have a dataset for 3 days I can not update it on Power BI service, knowing that on DESKTOP it is normally updated in 30 minutes. the dataset is powered from a server database, via a data gateway. the data gateway is well updated. the incremental update is activated and the dataset retrieves only the data of the last 3 days to each update. Monkey App Download

0 Kudos

cleverleys
Contributor

Posted on ‎08-17-2022 09:31 AM

I've managed to get it working today using the API rather than the PowerBi Connector....

I wonder if there is some throttling going on with the connector somewhere, but who knows 

0 Kudos