Forum Discussion

Timo_0n's avatar
Timo_0n
Icon for Helper I rankHelper I
2 years ago
Solved

Data incomplete in Power BI

Hello! We are using Postgre for data storing and connecting to Power BI by Direct Query. We have made several deshboards and loaded them to the server. Everything was working fine. But receintly ...
  • Timo_0n's avatar
    Timo_0n
    2 years ago

    so I think we found out issue.
    Before that let me explain how we were connecting BI to database.
    For security reasons we have 2 IP adresses, external and internal. Because internal IP don't allow for external users see data in our source, we were using External IP. It means, you can connect Internal IP to Power BI desktop, but upload it to the server with internal credentials and refresh it, it won't work.
    Because of that, we were using external IP adress for BI desktop server and then uploading it to the server. 

     

    So we tried again but with internal IP's credentials and that worked. So the problem was on Devops side, and it resolved.
    Thanks for attention!