0

I would like a way to change report data dynamically on a Power BI page.

Is it possible to insert an input component to load one Excel file in a page generated by Power BI, so all visual components automatically show it? If not, how can I accomplish that?

felipe.zkn
  • 2,012
  • 7
  • 31
  • 63
  • 1
    Where will your Excel files be located? Do you want to achieve so in Power BI Desktop or web? – Foxan Ng Oct 27 '17 at 13:04
  • @FoxanNg The files will be located in the user's local disk, as the input file component should upload it directly from it. The main goal is to publish the report. I can use both BI Desktop or BI Service. – felipe.zkn Oct 27 '17 at 22:05
  • The best you can do is to get file location as `Parameter` from users in Power BI Desktop. Does [this](https://stackoverflow.com/a/46088266/2684954) help? – Foxan Ng Oct 28 '17 at 10:29
  • @FoxanNg Thanks, but as the upload should happen on a web page (published report), I think this approach won't solve the problem. – felipe.zkn Oct 28 '17 at 15:13
  • I'm aware of this so I'm afraid that's the best you can do. What you're looking for is dynamic data source, where Power BI doesn't support (yet?). See, by the time you published the .pbix file to Power BI Service (Web), the data set is fixed and you can't change it. – Foxan Ng Oct 28 '17 at 15:43
  • You can take a look at [PowerApps](https://powerapps.microsoft.com/en-us/) which has [integration with Power BI](https://powerbi.microsoft.com/en-us/blog/power-bi-tile-in-powerapps/). This may be the end solution you're looking for. – Foxan Ng Oct 28 '17 at 15:50
  • Or maybe Power Update? – Mike Honey Oct 30 '17 at 07:25

0 Answers0