Forum Discussion

haryadihart's avatar
haryadihart
New Member
2 years ago

Power BI Table list show duplicated with suffix _R _L _M _V

Hi All,

 

We are creating a power BI dashboard from Power BI Desktop and found this,

the table are duplicated and have suffix _L _M,_R_V

 

can anyone help me explain what is this? and why is this happen?

the data source is using SQL Server.

 

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi  haryadihart ,

     

    My test using Direct Query to connect to SQL Server showed up fine and did not show multiple duplicate tables to reproduce your scenario.

     

    Is your Power BI Desktop the latest version, if not, you can follow the link below to bring it up to date.

    Download Power BI Desktop from Official Microsoft Download Center

    Can you elaborate on your steps, are you using append or merge operations when it comes to data, as Power BI creates suffixes for duplicate tables to differentiate, we can help you better.

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.