PowerBI Relationship Character Limit

Question

Hi there, I am currently running trying to run a relationship within Excel/PowerQuery and have not been able to get the one to many relationship. I have checked multiple times for duplicates and it says no duplicates even when eliminating any space and any characters other than letters. Since the column I am referencing is pretty long, I am wondering if there is a character limit when building relationships. Any help would be appreciated.

Answer 1

Hi @GregoryLeban-8711,

I'm sorry that Power BI is currently not supported in Microsoft Q&A. There's a forum which dedicated is to Power BI: https://community.fabric.microsoft.com/t5/Microsoft-Power-BI-Community/ct-p/powerbi. I would suggest post a new thread there. Power BI experts actively monitors questions there and will help you ASAP.

As per my limited knowledge about Power BI, there is no character limit when building relationships in Power BI Desktop. If you are having trouble creating a one-to-many relationship, it could be due to a referential integrity issue or a foreign key column being null. Make sure to check your model and relationships for any errors.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.