Dashboard long loading time
Hi, I have published my dashboard, where my data is in Europe and power bi server of my company is in Singapore. my dashboard pbix files is 110kb and 1 table with 5 columns is imported. it takes 2min to load. Could you please let me know why.. I tried all methods, removin unwanted columns and less visualization.
The most efficient way to perform lookup in table
Hello guys, how are you? I'm having a very specific issue, and even knowing how to solve that in theory, I'm having serious performance problems, due to the obligatory use from a very heavy database - an azure cube developed by my company that provides data worldwide. I've come with an example in a fact table, where I have trips from loading vehicles with an initial weight in the beggining of the trip. I need to create a measurement (can't make new columns in the direct query) that calculates the initial weight for the next trip from this same vehicle. It's a very simple task with ALL filters and on, however the real table is not retrieving the data due to the mentioned size of the datamodel. I've been trying using the OFFSET funcion, but I'm not being able to make the logic work to my problem. Any suggestions? Below, the latest try I've made: Next trip weight = VAR vFrota = MAX('Shifts and Events'[VehicleUsedId]) VAR vData = MAX('Shifts and Events'[EventStartDateTime]) VAR vTab = FILTER( ALL('Shifts and Events'), 'Shifts and Events'[EventStartDateTime] > vData && 'Shifts and Events'[VehicleUsedId] = vFrota ) VAR vMenorData = CALCULATE( MIN('Shifts and Events'[EventStartDateTime]), vTab ) RETURN CALCULATE( MAX('Shifts and Events'[MeasureBeforeLoading(kg)]), FILTER( vTab, [EventStartDateTime] = vMenorData && [VehicleUsedId] = vFrota ) ) Below an example of how I'm trying to make the information appear: Thanks!
Incremental Refresh- have to refresh last 12 months data only dynamically
Hello All, I am stuck to schedule incremental refresh - I have to refresh only last 6 months data dynamically. lets see we have 5 oct 21 then last 12 months would be from nov 20 to till date . and if we in jan22 then last 12 months would be from Feb21 to Jan22 vise versa.. Please help me to get this . Thanks a ton VahidDM Tanushree_Kapse amitchandak Thanks once again.report server landing page no "loading" indicator
Our report server works fine, but something is missing which makes a poor user experience. When user types the report service URL in the browser, the power bi default page comes out immediately, but without any folder/reports, no user name displayed at the top right corner. This would make users think the report service is empty, no content. It took about 40 sec to 1 mins for those folder names & reports loaded, and user name is also displayed at the upper right corner. Waiting for 1 mins is fine , but I wish there were an indicator to show "Loading" or the browser symbol keep spinning, sort of signal. Has anybody have experience in improving the landing page?
Empty matrix visual (Visuals are loading)
Hello, guys! Could you help me with issue below. I've uploaded my report on Report Server and one Table (Matrix) don't show the data. I see the cirle with "Visuals are loading...". Other visuals are loaded ok. When I change level of hierarchy - matrix data appears, but I still see "Visuals are loading..." circle. If I change page in the report and then return back, bug "Visuals are loading..." disappear. (Tried in Chrome, IE, Edge. Cleaned cache in Chrome, but the bug is appear) P.S. Current page contains 2 matrixes and other charts. The first matrix always is loaded ok. Second matrix has that bug.
Can't load data in report
Hello, I am connecting to a mySQL database then i am loading some various tables into Power BI desktop. When i edit them in Edit Queries and load them after the edit an error pops up. I tried to Edit them first before loading them but without any success. Does someone know what is causing this error ? Thank you in advance, Pavlin
