Forum Discussion

zua's avatar
zua
Frequent Visitor
2 years ago
Solved

Custom Connector Navigator Performance Issues

Hello,    I implement a custom connector to get a connection to a special database.  Could you help me with performance issues when using the navigator?    I have built a 2 dimensional navigatio...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi zua 

    Based on your description, you can consider to optimize your data model. such as
    1.remove columns that are not necessary

    2.If you have large dataset, you can consider to use Table.Buffer() function to cache the data to improve the performance, you can refer to the following link about the function.

    Table.Buffer - PowerQuery M | Microsoft Learn

     

    Best Regards!

    Yolo Zhu

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi zua 

Based on your description, you can consider to optimize your data model. such as
1.remove columns that are not necessary

2.If you have large dataset, you can consider to use Table.Buffer() function to cache the data to improve the performance, you can refer to the following link about the function.

Table.Buffer - PowerQuery M | Microsoft Learn

 

Best Regards!

Yolo Zhu

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