Forum Discussion
SOS couldn't load the data for this visual
Hi everyone, I am incredibly new to powerbi--but I have run into this problem a few times and I haven't really seen a solution online that has helped me yet. I have a direct query to a few dataverse tables and I am trying to reference a custom column that I made in power query editor, and use the key influencer report referencing a standardized string function from another table. The discoveries table and the contracts table have a one to many relationship that I have added in powerbi, but the relationship formally exists in dataverse as well. If anyone could explain a solution to me like I am 5 years old, I would appreciate it so much.
2 Replies
Hi Anonymous ,
This seems to be more related to Transact-SQL .
You may visit https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?category=&forum=transactsql&filter=&so....
If that doesn't work, please refer to the answer to this post.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Neeko,
I have been using powerbi since last Thursday. The first solution you shared, I am unsure where to put that syntax.
The post that you shared, deleting the column is not an option because it is the column that is relating the two tables that I am trying to draw conclusions from. I really need a pro to break this down for me because I am not understanding why this particular relationship is an issue, when another relationship I have referenced in the same manner does not have the error pop up. I tried removing all of the null relational values as I saw from another post, but that did not help either.