Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Power BI Desktop - Performance Issues

Hi everyone, I’m having huge performance issues in Power BI Desktop, presumably coming from my web data requests. I’ve set up a bit more than 20 web data requests within one Power BI file, extractin...
Need Help
Show and Tell
Tips and Tricks
lbendlin's avatar
lbendlin
Super User
4 years ago

Do your basic transformations include table merges?  Are these data sources impacted by the formula firewall? Have you disabled data previews? Have you used Binary.Buffer or Table.Buffer in your queries?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Q: Do your basic transformations include table merges?
    A: Table merges are included.

     

    Q: Are these data sources impacted by the formula firewall?
    A: I do not think so, but I am not sure. How can I find this out?

     

    Q: Have you disabled data previews?
    A: Yes - no change

     

    Q: Have you used Binary.Buffer or Table.Buffer in your queries?
    A: I do not know what these things are. I use the default settings.

    • lbendlin's avatar
      lbendlin
      Super User
      4 years ago

      Try to avoid merges. Do the joining in the data model instead.

       

      Buffers are your friend. They help you avoid pulling the same data multiple times.