Aged Receivable Grouping Module - Couldn't load the data for this visual error

[Anonymous81]

I am following along with the Dynamic Aged Receivables video. However, when I try to create the Total_Invoices measure (Total_Invoices = SUM(Invoice_Amt)) I get an error:

I’ve also simply tried adding the raw field Invoice_Amt to a table and I get the same error. I am able to add every other field to the table without and error (Invoice_ID, Due_Date, Invoice_ID, Invoice_Date, etc. ) There seems to be something about the Invoice_Amt field that triggers the error. I have tried clearing my cache, recreating the table and data set, and restarting my computer. Nothing seems to help. Per the videos, my data model looks like this, and both of the date relationships are inactive (dotted line).

Data Model:

Has anyone run into this issue or does anyone have a possible fix or workaround?

[ystroman]

Hello @Anonymous81. to help the forum members further analyze your current state and visualize your issue, could you please provide as many as you can of:

• Your work-in-progress PBIX file, using sanitized data if necessary
here’s [/u/brianj]@BrianJ’s YouTube video on how to anonymize data in a Power BI file: https://www.youtube.com/watch?v=VmWD7Ayw_NI
• Your dataset as an Excel file (again, sanitized if necessary)
• A detailed mock-up (marked-up screenshot of the visual in question or Excel file) showing your desired outcome.
• What is the EnterpriseDNA course/content referred to (provide URL)
• What is the video (provide URL)

Also, if you provide DAX or Power Query code in your post, please format it using the built-in formatting.

To clarify the conversation, on stackoverflow.com today, a very similar issue and model was self-solved hours later by changing the data type of the Invoice_Amt field from decimal to whole number. After this change and a refresh, everything worked as expected.

What is the cause of the Can’t Display Data error message for a Decimal Field in Power Bi

Posting Details from Stackoverflow Post

I have a data set that I have created in Microsoft Fabric. It’s a relatively small table of invoices that includes Partner_ID, Invoice_ID, Invoice_Date, Due_Date, Invoice_Amt. The table is part of a dataset that also includes a DIM_Date table and a DIM_Partner table. When I connect to the dataset in Power BI, I am able to drag all the Invoice table fields into a Power Bi table visual except for the Invoice_Amt field. When I drag this field, I get an Error:

I tried a variety of fixes I’ve seen online, including clearing my browser cache, restarting my computer, and recreating the table and dataset. I also did not find the specific error I got (file seethru.cpp; line 2162, function ‘From FLBA’) when I was researching the error. Has anyone else come across this error, and is there a know fix or workaround? As noted in my question, the Invoice_Amt field that causes the error is a decimal data type.

The Data Model is fairly simple - Many to 1 from Dim_Date to Due_Date and Invoice_Date (both relationships are set to inactive), Many to 1 PartnerID to Partner_ID.

• powerbi
• azure-service-fabric

Share

Improve this question

Follow

edited 3 hours ago

asked 3 hours ago

Mutuelinvestor

3,3841010 gold badges4444 silver badges7575 bronze badges

Add a comment

1 Answer

Sorted by:

0

After some more trial and error, I changed the data type of the Invoice_Amt field from decimal to whole number. After this change and a refresh, everything worked as expected.

For this particular data set, moving to whole numbers is OK, but I’m sure that will not always be the case. Would be nice to know what the issue is with the decimal data type.