Forum Discussion

Frequent Visitor

3 years ago

Improve the data loading performance of table visual

Hi all. I have started preparing a Power BI report to visualize information using table visual with drill down information option in a secondary tab in the same report. I want to increase the speed ...

Memorable Member

3 years ago

IzuruWi Have you checked visuals/query performance through Performance analyzer or DAX studio?? It can give you a fair idea about the visual performance that takes most time to load.

Frequent Visitor

3 years ago

AbbasG I have checked those and found it was were OK. But still the issue is same..

AbbasG
Memorable Member
3 years ago
IzuruWi can you share sample data or pbix after removing the sensitive information?
- IzuruWi
  Frequent Visitor
  3 years ago
  AbbasG This executes on direct query connection. So, there won't be any data in the pbix. Couldn't change it import mode, because of after few sets of records it'll stops import and gives an error
- IzuruWi
  Frequent Visitor
  3 years ago
  Hi AbbasG I found this dax causes some sort of a performance issue for the visualization. Can you please guide me to improve this dax?
  SWITCH (
              TRUE (),
              CONTAINS (
                  DIM_ANALYTIC_STRUCT_ACCOUNT,
                  DIM_ANALYTIC_STRUCT_ACCOUNT[STRUCTURE_NODE (groups)], "1 - CURRENT ASSETS"
              ), SUM ( FACT_CONSOL_BALANCE_OL[BALANCE] ),
              CONTAINS (
                  DIM_ANALYTIC_STRUCT_ACCOUNT,
                  DIM_ANALYTIC_STRUCT_ACCOUNT[STRUCTURE_NODE (groups)], "2 - NON - CURRENT ASSETS"
              ), SUM ( FACT_CONSOL_BALANCE_OL[BALANCE] ),
              SUM ( FACT_CONSOL_BALANCE_OL[BALANCE] ) * -1
          )