cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
P_Crane31
Regular Visitor

Data model refreshes on Desktop but not Service: can't figure out error codes

To start off, I'm rather new to PBI so I'm kinda building the airplane while in its in flight.

 

I am trying to set up a set of reports that refresh often (no fixed time need, but more often than every 30 minutes). My research has led me to Direct Query. My data lives in the cloud and it is PostgreSQL with a Personal Gateway and a "PRO" account.

 

To do ODBCPostgresDirect I apparently needed a custom data connector (??) which I got and installed from these links:

 "DirectQuery with Postgres from PowerBI Desktop | by Scott Goley | Just Readr the Instructions | Med... 

and 

Connector extensibility in Power BI. 

So I'm pretty sure I have a functioning ODBC driver (Unicode x64) and system DNS. I say that because I can load and refresh my data model on the PBI desktop app. I hit the wall when I try to use the reports on PBI Service. 

 

When I do a manual refresh I get the little orange triangle with the error message:

 

5-5-22_Error_screen grab.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Going into the settings I'm presented with: 

 

Settings error _1.png

 

 

 

 

 

 

 

 

After trying "Discover data sources" I get this response:

 

Settings error _2.png

 

 

 

 

 

 

 

 

 

 

My Google-Fu has reached it's limits. 

 

Thank You!

1 ACCEPTED SOLUTION

Thanks again for responding @GilbertQ ,

As it turns out, I had forgotten that I moved our gateway to a different machine from the one I'm working on currently. Once I logged this machine in to the gateway, everything worked fine. 

 

P.

 

View solution in original post

3 REPLIES 3
P_Crane31
Regular Visitor

Hi @GilbertQ. Unfortunately none of those steps helped. When I use the native data source PBI won't connect (connection time out). If it helps, Ive only had success with ODBC connections (hence that 3rd party connector). 

GilbertQ
Super User
Super User

Hi @P_Crane31 

 

I would use the native Power BI Data source as shown below

GilbertQ_0-1651789332867.png

 

When you connect to the data it should then ask you if you would like to import it or DirectQuery. You select DirectQuery.

 

 

 

Then in your gateway you would need to configure the connection details with username and password to connect via the gateway through to your database.

 

Power BI data sources - Power BI | Microsoft Docs

Power Query PostgreSQL connector - Power Query | Microsoft Docs





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Thanks again for responding @GilbertQ ,

As it turns out, I had forgotten that I moved our gateway to a different machine from the one I'm working on currently. Once I logged this machine in to the gateway, everything worked fine. 

 

P.

 

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors