Forum Discussion

JohnHedges's avatar
JohnHedges
Frequent Visitor
3 years ago
Solved

Online Service - Concurrent Users

Hi,   I have been developing a report over the last year or so and slowly rolling it out over our organisation (a group of 13 schools). I have got to grips with the development side of Power BI/DAX...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    3 years ago

    Hi, JohnHedges 

    This is usually related to the connection mode of your report.

    If you are currently using import mode, data is cached in power bi service  and the risk of performance issues is probably very low. If you are using DirectQuery and a large number of users are accessing the report online at the same time, there will inevitably be some performance issues, as the data query of the report happens every time a user interacts with the visualization, which consumes a lot of resources.

     

    Therefore, in addition to using premium capacity to expand resources, it is recommended to use the import connection mode to create reports, and try to access data reports during off-peak hours.

     

    Best Regards,
    Community Support Team _ Eason

v-easonf-msft's avatar
v-easonf-msft
Community Support
3 years ago

Hi， JohnHedges 

What data source and connection mode are you using when creating reports in Power BI Desktop?

 

Best Regards,
Community Support Team _ Eason

JohnHedges's avatar
JohnHedges
Frequent Visitor
3 years ago

I have loads of data sources!

 

It's pulling together nightly exports from multiple systems (pupil details, attendance, behaviour, rewards, suspensions, attainment etc)

 

Most of these are folders containing csv files or excel files, with one folder of xml files containing student pictures.

The schools' management systems are updating the files automatically each evening and I have Power BI set up to refresh daily at 2am.

 

I'm poking around on the webpage, Power BI Desktop, and PQE, but I can't find anything about connection mode.

 

 

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    3 years ago

    Hi, JohnHedges 

    It doesn't seem to be a problem with the connection mode, because the data in the csv file or excel file are all imported data. 

    You may need to check the influence of RLS. If RLS is provided for all users, Power BI has to query the backend server individually and cache a separate report for each user, which can degrade report performance.

    https://www.youtube.com/watch?v=nRm-yQrh-ZA 

     

    Best Regards,
    Community Support Team _ Eason