Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am working in PBI and made some updates to my underlying data stored in a csv. The updates were in a categorical variable column and upon refreshing the data in PBI I get an error message stating PBI can't find a seperate numeric column which it was previously loaded without any problem.
Any thoughts?
Hi @datamunger1245,
If I understand your scenario correctly that your report contains R visual and you get this error when you modify the underlying data source?
How do you modify the data source?
If it is convenient, could you share your error message with screenshot?
Best Regards,
Cherry
Sorry - that initial post could have been a bit more clear. I was working with my data in Rstudio to tidy it up. Saved my data as a csv and loaded it up in PBI. I notice PBI doesn't deal with NAs and when there's one or more in the column where I should have numeric values. PBI views the column as a text column data type. Upon noticing this, I went back into R to omit my NAs, saved the csv and loaded it up into PBI w/out NAs. However, PBI still won't view the column as a numeric data type....even after refreshing and multipe saves to the csv pulling out NAs.
It would be great if PBI could deal with NAs. Second is there a way PBI can refresh correctly to view my underyling data.
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |