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.
When merging tables on Power query my data then dissapears on the data tab on the front end/visual end of power bi desktop.
Very tempemental. Some times when I merge tables the data pulls all the way through, but sometimes the data seems to dissapear. I can see the data in the Power Query window but not on the Data tab when i close and apply.
Sometimes, when it doesn't work, I delete the report and start again from scratch and then it works fine.
I feel like this might be a Power BI Bug as I do the exact same thing every time and it never seems to be consistent.
The tables are all coming from SQL queries.
Look under Options and settings and play with the Query cache size to see if it makes a difference.
Also consider that changes in your data source content may impact the final outcome, depending on what transforms you do. Hard to tell without seeing the code.
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.