Forum Discussion
Solved
Power BI Desktop Shows Data, Online Service is missing 2 columns
Hi, I have the great report in the desktop that works brillantly. When I publish it to the service and it is refreshed, two pieces of the data just disappear. I have deleted and reloaded. I have ...
one thing you can try, instead of merging the tables, bring them in as 2 different table with a relationship. And use this to confirm if the data is there.
It's not a refresh issue, but I'm thinking it might be a merge issue. I'm an accountant that is neck-deep in this, but definitely not a programmer so it seems to me that when I merge tables, that gives the online service some trouble? Is that true?
- Tutu_in_YYC
Super User
Possible. There are some merges (depending on the data sources) that will not work for various reasons eg data privacy settings
- Tutu_in_YYC
one thing you can try, instead of merging the tables, bring them in as 2 different table with a relationship. And use this to confirm if the data is there.