+22Create a Power BI writer to enable use with FME Server to allow for automatic updates to Power BI dashboards without having to refresh/ping original (database) source.
Power BI Writer question: https://knowledge.safe.com/questions/59410/power-bi-writer.html
+22Hello, for those that are interested in a Power BI Writer, can you elaborate on your use case? What functionality would you like to see? Is there anything that's an absolute must? Let us know in the comments.
Power BI allows the developer to access data either by a direct connection to a database or by importing a dataset from a database. The import makes the operations in the Power BI report faster because the app doesn't have to go directly to the database, but the data is not fresh.
Are any plans to create an FME writer that could access and write to Power BI to emulate the import process? That way an FME script could be run on a regular basis to refresh the imported data.
+5I would like to render a cartographic grid with thematic colors based on a column value and pie-wedge polygons as two layers that go into a PBI-rendered ESRI map.
+26We are using Power BI more and more, and would love to see this writer, would make life so much easier
Not sure i see the point of a PBI writer.
We use PBI & FME for almost all our reporting, but we just update the PBI data sources with the regular FME writers (excel, sql, csv whatever) and then trigger the PBI Refresh on our report server.
We've made a custom transformer (basically a parameterised http caller) to do the refreshes.
+10Whilst being fully aware that PowerBI can consume .csv and .xlsx I have voted for this. I'm assuming the dedicated PowerBI writer would write out a .pbix file.
