Dataflow merging two excel tables Publishes as Blank Table in PowerApps

(0) Share

Report

Posted on by SRVAdmin

Hi, Happy New Year!

I am having a strange issue, and I am new to PowerApps, which makes my issue even more frustrating, ha.

I have two excel spreadsheets that I need to merge into one for a Dynamics lead table. Each spreadsheet contains different info, but both have a common ID. I figured the dataflow feature in Power Apps would be a good bet, and added the data, cleaned it, merged the two, cleaned the merged, and Published.

In PowerApps, I can see the table, and I see the log information on who published, time, etc; and some data fields populate, but with wrong info. For example, I have Lat/Long data on each row, and in the published table, it shows as zeros. In the Power Query editor, it is formatted correctly and shows the Lat/Long data.

I have tried to make new dataflows, but each one does the same. When I upload an Excel table as a 'new table' in PowerApps, the data shows correctly. While I can do this, I'd like for the merged tables to show in the dataverse so I can then connect & make a PowerBi report to embed alongside the data in Dynamics, showing an interactive map for my users.

Any help would be appreciated, thank you!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (0)

KoJaPD 601 on at

Like (0)

Report
Copy link

Link copied!

probably the problem with the lat/long data is a mismatch in field types (text vs numeric).
Maybe you can share some code/screenshots so we can look at it...

Was this reply helpful? Yes No
SRVAdmin 11 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your reply!

Unfortunately, I cannot share actual data, but here is a screenshot of the homepage. I've Taken Data1 & Merged it with Data2. In the screenshot, you can see both Lat/Long are decimals, and I checked all rows for any text, which there is none.

When I get to the Map Tables menu, the data is showing up as a ' Floating point number'. Could that be causing issues? How do I change that if so?

Here is a screenshot of how the data shows when published. I moved the NAICS codes next to Lat/Long, to show that text entries show, with limited errors.

This is a Dynamics Premium trial, could that be causing issues?

Thank you again for taking the time to help!

Was this reply helpful? Yes No
KoJaPD 601 on at

Like (0)

Report
Copy link

Link copied!
very strange indeed...
I have tested the scenario, and could not reproduce your error:
my powerquery:
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMtAzMFTSAVFGSrE60UqGegbGQD6QMlGKjQUA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t]), #"Changed column type" = Table.TransformColumnTypes(Source, {{"Column1", type number}, {"Column2", type number}}) in #"Changed column type"
the resulting table:
the mapping:
the dataverse table column definitions:
the result after the dataflow has run:

Was this reply helpful? Yes No
SRVAdmin 11 on at

Like (0)

Report
Copy link

Link copied!

Interestingly, looking at my code, each number (except for auto code, which is Int64.Type), including Lat/Long is 'type number'.

Would the source type being a .xlsx upload be causing an issue? I'm going to try and upload to OneDrive, then a Power BI Semantic Model, to see if that has any cause.

Do you know what happens in-between publishing & PowerApps building a table?

I did try the same Query via excel & it works perfectly, however, I would love to automate it within PowerApps DTR.

Thanks!

Was this reply helpful? Yes No