The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
It's all a bit too abstract for me to diagnose accurately.
Did you try what I suggested in my last post?
--
From my earlier post -
"are you saying a visual is not showing correct data because the relationship doesn't appear to be working" - You have to prove this true or false before going any further.
Another forum? - This is hard to take, I'm offended. I can't go on. No, it's OK, I feel better now.
Put the two fields that are related (one from each table) in a table visual. Make sure each is not using an aggregation for this test. If the relationship works, you will get a neat matchup for all fields.
@HotChilli - I posted in our internal company forum, so just to see if any immediate colleagues regcognized the issue, then we could deep dive into the data. I think this forum is probably the best place to stay otherwise 🙂
I looked at my setup again on the data model and all of our fields are full with customers and carriers. This model is published as a dataset in our workspace environment and then I have reports built that are connected to that dataset.
It is only in the reports that are built with the data source connection to the dataset that are missing data, not the actual model itself. When I test in sheets with the data model file, everything is all there.
Do you have any thoughts on what else may be occurring?
Is there any way for me to view all filters at once to see if I have a phantom filter somewhere?
Hi @HotChilli, I believe the latter. The data exists in the dimension table, but is not pairing as expected. I posted in another forum and people also suggested that it may be hidden characters. I am going to try creating a trimmed version of the key and see if that resolves. Are there any other methods or processes you would suggest to resolve?
Do you mean the data is missing from a column (in Power Query)?
or are you saying a visual is not showing correct data because the relationship doesn't appear to be working (usually spaces or hidden characters in a field)?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
101 | |
94 | |
80 | |
63 | |
56 |
User | Count |
---|---|
247 | |
122 | |
110 | |
77 | |
72 |