Forum Discussion

niyati_61's avatar
niyati_61
Icon for Helper III rankHelper III
2 years ago

Power BI Data Loading Issue

Hi All and d_gosbell ,   I'm facing this issue currently.   Say I have about 20 tables of data in the Power BI Query Editor.   I update manually about 5 tables in the Query Editor (Manually upd...
Need Help
Tips and Tricks
CoreyP's avatar
CoreyP
Icon for Solution Sage rankSolution Sage
2 years ago

Can you share some additional detail? Maybe a screenshot of the queries? Or of your model? Why do you have so many tables, and why do they require manual updating? There might be a better way to architect your data source(s).

niyati_61's avatar
niyati_61
Icon for Helper III rankHelper III
2 years ago

Hi CoreyP ,

 

Yes, I do have many tables in one PBI Report (PBIX File) itself. There are about 15 Dashboard pages of data in one dashboard for example. So, for that about 20 or more tables of data are present in the Query Editor.

 

This is because I need to have multiple departments project to be displayed in one PBIX File itself. Eg: Engineering, Procurement, Warehouse Department, etc.

 

Sometimes the data tables require manual updating - as they are custom tables created - where I update the data weekly, or if the table is connected to an excel data source and I need to refresh it and add some manual data, etc.

 

But right now, as mentioned in the primary issue, not sure why when I update 5 tables - only 2 tables actually get loaded and refreshed in Power BI.

 

Let me know!

  • CoreyP's avatar
    CoreyP
    Icon for Solution Sage rankSolution Sage
    2 years ago

    Can you provide a screenshot of your queries in PQ? Is the name of the query in italics? If so, it might have load disabled or not included in report refresh.

    • niyati_61's avatar
      niyati_61
      Icon for Helper III rankHelper III
      2 years ago

      Hello, no none of the queries have been disabled. They are all enabled.

       

      I'm not sure I can provide data screenshots, due to confidentiality purposes.

      • CoreyP's avatar
        CoreyP
        Icon for Solution Sage rankSolution Sage
        2 years ago

        Totally understand about confidential data, no need to share that. Unfortunately, I would need a lot more details to be able to diagnose your issue.