Data loading time when I want to open the report
Could someone please tell me what I could do to reduce report data loading time? Currently, it takes around 80 seconds, and the report size is approximately 700 MB. Also, it confuses me that after the initial slow loading, every subsequent report opening is instant, without any waiting. This lasts for about an hour, and then it goes back to slow loading. Is there a way to extend the period of instant loading throughout the entire day? Please help!
Power BI Dashboard shows 'Load Data' message twice every time I click on the report link
I have a power Bi dashboard (deployed to a report server) where I have imported the data (query folding is in place), but every time that I click on the report link it shows a message of 'Load data' 2 times before it displays the report. To allow me to test this on a simpler dashboard, I created a power Bi dashboard where I have imported 1 view with only 3 columns and I have deployed to the server, but I still get the 'Load data message twice every time I click on the report link. Why is Power BI showing this message twice and is there a way to disable it as this is causing delays when loading other reports. Is it because of one of the following? Data eviction Is it due to how Import uses the VertiPaq engine to store data in memory? Power BI wants to know the schema of the table before the query actually runs, so it asks Power Query to return the top 0 rows. Unfortunately, in this case query folding can’t take place and the top 0 filter can’t be pushed back to the database, so the entire query gets run once to get the schema and once to get the data. Or is there another reason for this and is it possible to disable this? Thanks J
Azure MySQL - Architecture advices
Hello all, I have a case where we have data processed and stored in BigQuery Google service and have to transpose it to Azure MySQL and connect it to PBI to allow several users to develop dashboards and read them. What we chose to transfer data is to go from big query to google cloud storage and split the DataFrames in CSVs Then from GCS to Azure for MySQL and UNION those CSV, the final result will be two DataFrames with approx 70M rows. (25 gigs of data in CSV), I believe a daily refresh will be more than enough. Relative to this I have several questions: - Is Azure MySQL a good choice of DB to tackle this problem or should I use another service: Azure SQL, Azure spark...? - In terms of data load it will be impossible to work with the full dataset locally and direct query is not available on MySQL, is it possible to define the database structure, types.. in the web version, program incremental imports and work locally with only a portion of the dataset ? I remember having issue when trying to have the whole data loaded on the web and loading only a sample locally... - Do you have an idea of the pricing plan we should go for to support this data load? The free PBI version only allows to store dashboards with 1 Gig of data I believe. Thanks for your answers =D L
Data loading on Report Server
Hi ! Is it possible to automate the loading of data but separately ? I would like to re load data of my TABLE 1 once a month. & I would like to re load date of my TABLE 2 once a week. I'm able to do it manually but how can I automatize this ? Thanks by advance, Have a nice day,
