cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Jmenas Member
Member

Postgres SQL increase the size of the .pbix file to > 1GB

Hi all,

 

I don't know if someone had the issue with Postgres SQL server, the file size increase drastically. 

Our file was only 90mb with OData but with Postgres SQL the file size is more than 1GB (around 80M rows). 

 

Does Anyone have an idea why is this happening? I assumed that it was the data model but I check and everything is fine. The load of the columns also. 

 

I have a hypothesis: The connector downloads all the designated database into the Pbix file. That means that the file is the actual Database from the server. Can it that be? 

 

Best,
J.

 

4 REPLIES 4
Community Support Team
Community Support Team

Re: Postgres SQL increase the size of the .pbix file to > 1GB

Hi @Jmenas

Did you try two method to connect to Postgres SQL server, using ODBC connection or Postgres SQL database connector?

This issue happens for the second method, right?

 

 

 

Best Regards

Maggie

Jmenas Member
Member

Re: Postgres SQL increase the size of the .pbix file to > 1GB

hi @v-juanli-msft

 

I am using the PostgreSQL.Database, so to answer your question yes. Can I change it? should I set it up similar to http://jaykilleen.com/posts/connect-powerbi-to-a-remote-postgresql-database-encrypted-with-ssl?  

 

Thanks,

 

Best,

J.

MoorsTech Regular Visitor
Regular Visitor

Re: Postgres SQL increase the size of the .pbix file to > 1GB

Hi @v-juanli-msft,

 

no, we have not actually tried connecting to the PostgreSQL database using the ODBC datasource type.
I'm guessing from your question that this is a somewhat known issue when using the PostgresSQL type connector, so we'll give ODBC a go and report back.


Thanks a bunch!


Cheers

Lukas

MoorsTech Regular Visitor
Regular Visitor

Re: Postgres SQL increase the size of the .pbix file to > 1GB

We've just did a test using ODBC to connect to the PostgreSQL server with roughly the same result. In fact, in one test, the ODBC dataset size increased by ~ 10%.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors