Forum Discussion
Solved
Postgresql database and relational tables - refreshing locally works but refreshing on gateway fails
In a nut shell my company's power BI has a table (Original Table being queried) that has relational columns that are foreign keyed to a different table. What happens locally is that you can "Expand" ...
There are four different mashup engines at work
- desktop
- gateway
- dataflows gen1
- dataflows gen2
- Power BI Service
(ok, ok, five)
There is no guarantee that these mashup engines work the same way (and there are known differences for example when it comes to encryoted connections)
Fetching related tables is generally not a great idea. Better to fetch each table separately, avoid the cost of expansion, and join them in the Power BI data model if needed.