Exporting a Table from PowerBI Service with Dynamic Filters
Hello PBI Community, I have been attempting to create a PowerAutomate flow within my PowerBI report to allow users to select a button to export the table on the report into a SharePoint folder. I have been facing some difficulty with this flow so I was hoping this community could help solve it. For context, I have a published PowerBI report with a normal table visual on it. I am attempting to add the PowerAutomate button to the page with a linked flow that, upon clicking, triggers the export of the current filtered table, with page slicers applied, to a SharePoint folder. The two filters/slicers that are key for the filtering and dynamic exporting are "Asset" and "Work Order Number". I've tried a few different methods, with some success on getting the table exported, but not filtered down to the "sliced" view. Has anyone dealt with something like this before?
Getting sorted data in bunches
Hi All We have a dataset with 100K rows in the following format: And we have a flow that is getting data from this dataset Due to the fact that flow cannot get all 100k rows in one go we are getting it in bunches of 25k rows, using autoincremented index, after that we are creating csv file from it - no problems so far. But we also need to be able to sort data by any of those columns and then get data in 25k rows bunches, so we cannot use min-max ID for that any more 😞 , and becouse we have a lots of columns, creating index for each column is not an option, all to be done dynamically. So the question is - how can we get 100k rows of dynamicaly sorted data from dataset into flow ? Thanks
Text filter
Hi everyone! sorry if my question is a dumb one.... I am almost sure what I am asking is impossible. 🙂 I have a requirement where I would like to store all the searches in a TEXT FILTER visualization that have no results. The idea is for a KNOWLEDGE BASE and I would like to understand what are the users searching with no results so I can create that new content. Is it possible to somehow use the string used in TEXT FILTER in a measure or something in order to trigger somehow a flow with Power Automate?
