Flow Button showing Unsuccessful when another user is clicking after publishing
HI, I have a simple flow set up that's connected to the newly released Flow button in Power BI. When I click it, I get "Triggered" text, then "Run flow" text. The Flow then runs and works. However, after publishing the report to my workspace then sharing it to another user, the flow button shows "Unsuccessful" text and there's no way of troubleshooting it. I don't see a failed run for the associated flow. How can I further troubleshoot this?
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
Power Automate Flow Button to a Power BI report from another environment
From Power BI, I am trying to use Flow to update a table from Environment B within Dataverse. My Default environment is Environment A. Is it possible to change environments in Power BI to create a flow within Environment B or is it possible to use an "Update a Row" and select the environment? The current "Update a Row" in Dataverse option only shows tables from environment A (see image).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?The Ultimate CDS Power BI Explorer Part 1 – From Zero to Hero
Ever wondered if there might be a better way of navigating around your Power BI reports? In this article we go through all the steps needed use the Power Platform to surface any of your Power BI Reports. It's like a one-inch punch - 1 PowerApps Power BI tile can surface 1000 reports. What's more is that we can refresh our reports at the click of a button by connecting Power Apps to Flow, and Flow to Power BI.
Know and manage the data process flow for performance
Hello everyone! I have this environment: SQL Server 2017 (latest patch) with data SSAS with Import Model Power BI Report Server in Connect Live Mode with SSAS Model I would like to know how this entire environment works with memory usage, like RAM and DISK.... Is there a data process flow that explains how the data navigates from the database to the final report? I want to prevent any performance issue or server crashes. How can I read some info about it? Just an example: If I have a tabel with 800k records... how does it translate into ram and disk consumption? What I have to configure? Server RAM? Client RAM? SSAS RAM Configuration? Many thanks! Riccardo
