couldn't load the data for this visual. power bi dashboard embedded in power apps

[Krishna09]

Hello all,

I have embeded dashboard report to power apps (tileURL). it can be accessed succesfully. but when I scroll down to load the data. I have below error. there are choices fields as well in dataverse. I am using dataverse as data source. I do not understand error properly. Can any one please help me how to solve this and understand this error?

Thank you 

[R1k91]

when I asked "are you joining 2 tables?" you replied "yes".

anyway, so the root cause in somewherelse.

maybe you're trying to convert some columns to int even if they're not convertible.

easiest way to find the problem is to access Dataverse directly with SSMS or Azure Data Studio to look at the data.

maybe in power query you could try to use "Replace Errors" for all the int columns replacing the content to a specific value that you can recognize later in order to find wrong lines.

[Krishna09 · Accepted solution]

Hello,

I found the solution. this error was because of calculated columns in my datasource. i converted all to text. it solved the error.

[Krishna09]

Sorry @R1k91 , I have misunderstood. Thank you for you time. I tried to to replace errors with "NA123" it didnot work. How to check errors in SSMS?

[R1k91]

the problem is in dataverse not in power query.

you'll probably have different types.

if your join is like this

TableA.column1= TableB.column1

column1 must be varchar in both tables and it seems they're not in your case.

[Krishna09]

I am not joining any tables. I have three tables in dataverse. I am directly shows these three tables in three individual pages in table visual.

[R1k91]

where did you check the data type?

dataverse or power query?

[Krishna09]

I checked in Power query

[R1k91]

I expect Power Apps to page data therefore you're seeing the error just because only few rows in your dataset have this problem. when you scroll you retrive new data from the server and you catch rows with errors.

check if you have different data types for the joining columns. 

[Krishna09]

Hello @R1k91 , I rechecked with the type of all columns, all fields have been assigned with respective types. But among many rows how can I find error? 

As I am using directquery (not import) i could not verify all of them in the power query

[Krishna09]

yes , the tables are in dataverse with choices columns as well. I could see the data but only few rows are visible. after some records, it shows this error. but when I apply filter it to limited date its shows fine. Is that converstion error because of huge data? the table have around 2lakh rows.

[R1k91]

are you joining 2 dataverse tables?

it seems a convertion error while doing a join