PBI reload error message viewer

[adelmonte]

Hi all,

When I reload my PBI, reload process finishes successfully, but on one source I get errors.
Is it possible to view errors of reloading process in PBI?

Errors:

Thanks,
Alex

[v-shex-msft]

HI @adelmonte,

Does any update on your data source side that affects the data table structures?

AFAIk, power bi will cache the data structure into the query steps, these cached structures are not auto synced even if the data source structures changes. (not matched records may affect the function usages)

Regards,

Xiaoxin Sheng

[adelmonte]

Thanks for your answer.
I tried with a brand new PBIX and I get the same issue.

No additional tables nor sources are present.

[v-shex-msft · Accepted solution]

Hi @adelmonte,

Perhaps you can take a look at the following blog of report loading data errors if it helps:

Exception Reporting in Power BI: Catch the Error Rows in Power Query - RADACAD
Regards,

Xiaoxin Sheng

[adelmonte]

Thank you very much Xiaoxin!
This was a great tip.

[amitchandak]

@adelmonte , Check do see any column in the table with some red like or red stripe on it

[adelmonte]

Unfortunately, no red stripes or something unusual shows when I check my Table, Columns.
Thanks anyway.

[amitchandak]

@adelmonte , Open power query, on left table pane you should see folders for error

[adelmonte]

Thanks Amit but I don's see errors on left table pane 😞