PostgreSQL Table with more than 0x0FFFFFF rows+Error on Importing in PowerBI when a filter is added

[elvis_nica]

Hello,

I have a DataBase with some items in.

After the 268,435,455 (0x0FFFFFF) row was inserted in a table I have an issue with refreshing the PBI report.

I have a filter  that limits to only the last 1 million of items. Same error appear with or without it.

But. I imported in a new PBI Project same table again (lots of GB) and is working.

But if I add the filter, same error appears again.

If I remove the filter, the refresh is working.

Looks like the PBI report is somehow broken (maybe because is created some years ago and some info are missing from the project).

It is behaving like there are some duplicate items in the table (witch are not) - maybe because a convestion appears after an overflow.

I have installed multiple versions of Power BI Desktop. Same issue is present.

Does anybody know a solution for this issue?

Thank you.

[elvis_nica]

The solution is refering to Microsoft SQL Server 2008. I use PostgreSQL.

I could refresh the data and I could upload the project/app to the cloud.

But now, the database is bigger, something happened that triggers that error.

Is the same PBI workspace.

Thank you for your response.

[Anonymous]

Hi @elvis_nica ,

Please refer to the following topic to see if it helps you.

https://community.powerbi.com/t5/Desktop/OLE-DB-or-ODBC-error-DataSource-Error-Microsoft-SQL-Protoco...

If I am misunderstand your meaning correctly, Please contact me and tell me more details.

Best Regards

Community Support Team _ polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[elvis_nica]

Hello,

I found a ... solution. But I do not like it.

It is working on the local machine, but it is failing to refresh on the "cloud".

Any ideas why this hapens?

Thank you.