search

cityofaustin / atd-data-tech

Austin Transportation Data & Technology Services
17 stars 2 forks source link

[URGENT] Working in PowerBi to update TPWstat dashboards and receiving an error related to connecting to the ... #19556

Open atdservicebot opened 3 hours ago

atdservicebot commented 3 hours ago

What application are you using?

Other / Not sure

Describe the problem.

Working in PowerBi to update TPWstat dashboards and receiving an error related to connecting to the Socarata API Server. Logging in is not working and unable to connect to the data source to update.

Is there anything else we should know?

Need to update dashboards this week for Monday's meeting with executives. Screenshots attached.

Internet Browser: Internet Explorer

Requested By Jewelee D.

Attachment (151.92kb)

Request ID: DTS24-118425

susannegov commented 2 hours ago

Sent message through Teams

Hello reaching out about this issue that came in #19556

I saw from the screenshots that the sign-in method selected in Power BI is Anonymous/Organization account. For accessing Socrata datasets in the Data Hub, you will need to access it through a API and API key since the datahub is an internal website.

There’s documentation on how to set that up in SharePoint if you scroll down to Connect to Enterprise Data Portal (EDP) in Power BI Desktop

susannegov commented 2 hours ago

Gave the corrected link Connect to Enterprise Data Portal (EDP) in Power BI Desktop