User Profile
alohaes
Helper I
Joined 3 years ago
User Widgets
Contributions
PowerBI JS slicer configuration on a ranged date slicer is not working correctly
Hey fellas. So, I am applying an advanced filter on a ranged date slicer and settings its state using the settings slicers in the report configuration. Issue is that, when i view this report in edit mode in a embedded page and hover over any visual's filters which are tied to the date, I can see the slicer filters of date being applied on it 2 times and this is preventing manual user changes on the said slicer to be applied to other concerned visuals. PFB the screenshot that I have attached for reference. Appreciate any and all help to figure this thing out because its a really critical issues for us.Unable to connect to Azure SQL Server via Direct Query
Hey everyone. I am facing this error in powerbi service whenever I try to open this report which is connected through Direct Query to a SQL Server in Azure. Because of this none of the visuals are loading. Far as I can remember, the same report a few days back was not throwing this error but then suddenly it starts doing so. Not sure why. Below is the snapshot of the error: In dataset also, this error is showing up: I would really appreciate any help on this. Do let me know if any more information is required.Re: Impact of report level filter on capacity utilization
Hi Anonymous thanks for the reply. Yes, I am applying report level filter while exporting the report. I don't think the report has incremental refresh created so I will try that one out. Though I do have another question. Are the export workflow and sematic model workflow connected somehow when exporting? Like while exporting I believe an interactive refresh happens on the visual side but am not sure if it does in background side as well. If so, it would make sense to create an incremental refresh like you said 🙂Impact of report level filter on capacity utilization
Scenario: I got a non-paginated report that I am exporting via the REST api with some report level filters. The exports are done in a loop with each unique filter applied to that export. For testing, the loop increment is limited till 4. The dataset model is in import mode and there is quite a lot of data in the source db. Issue: The issue that I am facing is that when the exports happen, the dataset workload of Azure metrics shows utilization of more than 150% percent but the InteractiveReportExport workload shows almost nil utilization, like 3-4% at times. Question: So, I would like to understand whether the filters that I am applying while exporting are causing a massive spike in the dataset workload maybe because the model is not optimized or is there some reason for this? (Below I have also attached a snapshot of dataset utilization when I tested). Really appreciate all the help, thank you!Re: Will PageBookmark property take priority over ExportFilters property?
Hi, thanks for the reply. Even I assumed so and I made a small dummy project to check this out and its working as you mentioned. My filters are applying over the bookmark in the exported report but the weird thing is that in our prod application the same is not happening. The report gets exported with only the captured bookmark state and not our exclusive filters we are passing in the API. Even though the code and logic to capture the bookmark state and exporting the report is same as the POC. Though, the only difference is that the bookmark state being passed in our prod is first being encoded again into a base-64 string and then decoded back before making the export call. But even that doesn't have any impact on the POC export when I pass the state as hardcoded there. Is there any other property on PowerBI JS or PowerBI API SDK that we need to set when exporting report so that it takes the export filters over the bookmark state? Thanks for your help!Re: Will PageBookmark property take priority over ExportFilters property?
Hi thanks for the reply and sorry for late response. By saved filters I assume you mean the filters that are designed by the report author, if so then yes. The report in question has a date visual which I am trying to apply while exporting the report using DAX. And the bookmark is not saved I guess(I assume you mean the bookmarks made by author himself), I am capturing the state of the report using the capture() from PowerBI JS SDK. Please let me know if this information relates to your queries or not. Thanks for the help!Will PageBookmark property take priority over ExportFilters property?
Hi everyone. I am exporting a powerbi report using exporttofileasync method and passing the captured state of the report and a my list of filters to PageBookmark & ExportFilter properties respectively. But, the thing is I need to test if my export filters will apply over the state so while debugging I am changing the export filter to something else(but valid one) then resuming the flow to call the export method from the SDK. And, I don't see my export filter getting reflected on the exported report(on data and visual level both) but only the captured state of the report. Does the bookmark state take priority over the export filters while exporting a report? Thanks for the help!
