error

So...is the problem solved? I am not sure what your reply means.

No, but I discovered that problem is not in query, but in relation. I set it up, but It is not recognized correctly.

When I forget set up relation, it says- There is not relation.

But instead of that I have error, that I described before.

Error Message:

Při použití spravovaného rozhraní IDataReader došlo k následující výjimce: The conversion of the nvarchar value '5131032161' overflowed an int column..

I have relation  Table A->Table B

Columns A ->Column B

I had mistake

Column A was number

Column B was text.

I changed Column B to number, but there is still mistake.

You still haven't provided any of the information we asked you for earlier, so I don't know how we can help you. Just repeating that it isn't working doesn't help.

We need to know where this is happening and how. Is this in the query editor, the relationship editor, where? If it's in the query editor we need you to post the query code we asked you for. If it's happening in the relationship editor we need to know what you are doing when you get this error message. Does it happen when you try to create the relationship? Or are you getting this message somewhere else entirely? The report editing window, the table editor? What window are you in and what are you doing at the exact moment when you get this error message?

We also need to know about the tables and columns you're trying to relate. They must have the exact same data type (integer and decimal are both numbers but they are not the same thing, for instance). They must have values that actually match, meaning that the same value in Table A[Column A] must also exist in Table B[Column B]. They must also form a 1:1 or a 1:N relationship, which means that at least one of the two columns must have only unique values with no duplicates.

I fixed it, but the same error appear somewhere again,

Error Message:

Při použití spravovaného rozhraní IDataReader došlo k následující výjimce: The conversion of the nvarchar value '5131032161' overflowed an int column..

Stack Trace:

I know I can not decribe it well. Reason is that I do know what IDataReader, (conversion of the nvarchar value '5131032161' overflowed an int column..) means.

 Now it appears when I used extended filter- search by includes..... .

All I know when I throw some columns away it won´t appear. It seems It appears when table has too many calculations.

Maybe change column type Int to Decimal

I don't understand why you can't just tell us what window you're in and what you're trying to do when you see this error message. You don't have to understand what the error message means to know what things you can see on your screen.

What are you connecting to? Are you using the ODBC connector? Is it a Teradata Database? It could be helpful if you can give us your full query (Query Editor > Advanced Editor)

I have table on the page a I try to use advanced filer.

https://powerbi.microsoft.com/en-us/documentation/powerbi-service-how-to-use-a-report-filter/

when I use it. I have error instead of the table.

When I nulify advanced filter, I have table again instead of error

I do not know how I can decribe it better.

OK. What are you trying to use in that filter? A column? A measure? What data type is it? What value are you trying to sort with?

I would like to give information from

Query Editor > Advanced Editor), but I am afraid of giving my employer internal data to public.

I use DirecQuery and MS Asure

IT is column, Text  and type column that bear relation is also text

I don't think the problem is in the query if you're getting this error when you try to add a report filter. Just tell us about the filter. What are you using as a filter? Column? Measure? What is its data type? Is this a visual level filter, a page level filter, a report level filter? If it's visual, what kind of visual are you using it on?

And what value are you trying to set the filter to? When you go to Advanced Filter, what are you entering there? Are you typing in that 5131032161 number there?

---

pstanek wrote:

I would like to give information from

Query Editor > Advanced Editor), but I am afraid of giving my employer internal data to public.

I use DirecQuery and MS Asure

 

---

I understand your concern. You can censor the sensitive information with "####", we don't need to see the values or the table names, we only need to see what steps you're taking, what functions you call etc.