Data is blank in PBI Desktop while Data is showing in Power Query
My data is showing in Power Query but when loading data to desktop, it's blank.
Not too sure what to do or check. (been using PowerBI for 2 years now, never had this issue). I checked all datatypes of my merges (if this was an issue the data in PowerQuery would be blank too I guess), .. any other ideas?
Whether your problem has been resolved? If yes, could you please mark the helpful post asAnswered? It will help the others in the community find the solution easily if they face the same problem with you. Thank you.
Community Support Team _ Rena If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
After that, it seems there are 156queries from the screenshot you provided. Which query (table) is having this problem? Could you please share the applied codes in in the Advanced Editor for the corresponding query? Later, we will make troubleshooting to check if a certain step was applied to cause such a problem.
In addition, please check the following links with similar problems to yours. Hopefully the solutions there will also help you solve your problem. Thank you.
It seems to be a relationship problem. Are you using columns from different tables in your visual on desktop? If yes, check the relationship between these tables. Try to change the relationship type and/or filter direction.