Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
i've appended some data to my source excel spreadsheet and hit the refresh button. Only problem is, now my visualisations dont work. I;ve checked the column types, and all data seems to be correct. Any ideas?
Solved! Go to Solution.
@Philwantling aha!
you going to laugh when i tell you what the issue is
your filter on site, it says all but its lying, only hong kong is checked, i clicked on east and boom the data arrived
Proud to be a Super User!
@Philwantling and can you see data in your model?
Proud to be a Super User!
Yeah, i can see the data perfectly fine. If i start a new doc and get the same data, it works fine in the new document.
@Philwantling so you saying in a new power bi it works find with the same visual and the data but in the current it doesn't?
i dont suppose you can share your pbix?
Proud to be a Super User!
Hi @vanessafvg
That's correct.
yeah, sure thing. .pbix and original data enclosed here: Dropbox
The only differece to the native data and the model in PBi are the calculated columns for total load, DCiE and PUE.
@vanessafvg there's a video here showing the issue a bit more clearly: https://www.dropbox.com/s/b0sunpsyslqys2s/2017-07-17_14h27_45.mp4?dl=0
@Philwantling the only difference i can see is that in the one you use a date filter and the other you dont, with your incremental load are you sure dates are populated correctly?
Proud to be a Super User!
@Philwantling ok scrap that i can see in the first screenshot the dates are there
Proud to be a Super User!
@Philwantling to be honest its going to be really hard to figure it out without actually having access to the pbix,
Proud to be a Super User!
@Philwantling aha!
you going to laugh when i tell you what the issue is
your filter on site, it says all but its lying, only hong kong is checked, i clicked on east and boom the data arrived
Proud to be a Super User!
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |