Power BI Slicer - Between Dates don't get the latest date
Hello everybody!! I need some help with the date slicer on Power BI Desktop. When I create my Dashboard, I put an slicer between two dates, that are my first and last date based on my Calendar table (it's based on my first ticket creation date, on my tickets table, and "today" function). After, I publish it on my Report Server, set the schedule refresh, everything is okay. But on the next day, when I'll check the Dashboard, after the refresh, the last date wasn't the most recent date (or today, in that case), but the date when I published the Dashboard, so the viewer needs to slide the filter to the right to get the actual date, or click on the "clean filters" button. That's the example of date filter that I'm using. It was published on Jul,11 (it's on Brazilian format), and the second image, is the today refresh. Note that the first date changes too, because the Dashboard was published with data from Apr, 11 2019 to Jul, 11 2024, so at the refresh, my source data was only after Jan, 2 2023 There's some solution based on this? I've the latest release of Power BI Desktop and Report Server, but I didn't find any settings to do that. I've searched in a bunch of topics here, on Stack Overflow, Reddit, but didn't find anything specific for that.
data multiplexing
Hello everyone, I have 2 tables, one of them contains store code, sales amount, sales amount, year and month data between 2021 and 2023. My other table contains store code, target, year and month data between 2021 and 2023. I associate these two tables with the store code. However, while the store's sales amount is correct, the target is incorrect. I did a lot of research on why but I couldn't find it. Can you help me with this? Thank you good workQuestion on data limitation
I am in the beginning process of developling a data governance process at work. Does it make sense to require everyone who publishes a report to go through the PowerBI pipeline deployment process? I am skeptical because we currently already have an ecosystem of 140 workspaces. About 20% currently use the pipeline deployment process. If we create a governance that requires everyone to go through the pipeline deployment process, this would result in 300+ workspaces. My concerns are does this become to monstrous to manage? What is the best practice? and will I run into data storage issues? I know premium capacity allows us to have up to 100TB worth of data. The 1000 dataset limitation also scares me. What does this mean for pipeline deployment?
[Microsoft Learning Path] Visualize data in Power Bi
docs.microsoft.com/en-us/learn/modules/data-driven-story-power-bi/13-lab I'm trying to do this tutortial but when I upload the dataset as guided, the data won't show up. After detailed investigation, I found that the dataset can't be displayed because of the error displayed in the figure below. Please help me !
Data vanishes after a split second!Urgent help
Hi, The data seems to appears for a Split second and then shows zero.Please could someone help me on this. And the formula below was working so far and only difference now is that we updated the november upgrade recently apart from that no changes were made. AvgFIRM_SellingPrice = var firm_userprincipalname = [MF_USERPRINCIPALNAME] RETURN CALCULATE ( AVERAGE(IMPORT_SQL_monthly[SellingPrice] ),OR(IMPORT_SQL_monthly[CurrentStatus]="Sold", IMPORT_SQL_monthly[CurrentStatus]="SaleComplete"), TBL_CALENDAR_periods[Value] = "This year", LOOKUP_MF_USERS[PrincipalName] = firm_userprincipalname , IMPORT_SQL_monthly[PartShare] = 0, USERELATIONSHIP( IMPORT_SQL_monthly[DateSold], TBL_CALENDAR_date[Date] ), USERELATIONSHIP( IMPORT_SQL_monthly[MemberFirm], LOOKUP_MF_USERS[firm]) ) + 0 Thanks.PBI Report Server: import mode & data encryption
Hello, If I adopt import mode, the report is saved in Power BI Report Server. Is the report encrypted by default? Where is stored the report in the server? My report contains data affected by confidentiality information and I I have to guarantee encrypted data. Thanks for support, Marco.
