I am unable to find online if FME can read data from Power BI. We currently us an SSRS to pull data from multiple sources and write them to a xls file. According to our developers Power BI can't write an xls file the same way so we were wondering if FME can reach into Power BI to pull data out as a reader in the workbench.
- Contributor
I understand the functionality you appear to be seeking may be available within the Power BI service depending on your licencing level.
If you already have paid premium capacity in the Power BI service, a Power BI pro licence, and appropriate credentials to the PBI workspace and dataset - and you still can't get it to work , I would be very interested to know what FME could do to access the PBI service's data model using the REST API.
It would be great if FME takes the PBIX file and uses it to figure out the data sources and exposes the data it in FME.
Lots of updates on this one.
You can use Paginated reports for Power Bi and they can hook onto a Power BI dataset so you can use subscriptions to generate quite complex Excel outputs; if that's really of needed.
XMLA endpoints for Power Bi allow you to hook onto the underlying data in a dataset (PBIX) so you could pull data out and use FME to transform/write.
Hi,
FME (Feature Manipulation Engine) by Safe Software, a highly versatile tool used for data conversion and manipulation, does not have a native connector or reader for Power BI.
FME provides support for a large number of data formats and systems, but Power BI is not directly among them. Power BI is largely a visualization and reporting tool, and it is not designed for other tools to reach in and pull data out of it.
However, you can look at alternate ways to extract data. You could potentially extract data from the same sources that Power BI is using. This is especially relevant if your Power BI data is being sourced from an SQL Server, Excel, or similar data sources, since FME has readers for these data sources.
If your data is directly in Power BI and you want to extract it to FME, you may need to explore other ways. One potential way would be using Power BI's export options to create a CSV, Excel, or other FME-readable file and then read that file using FME.
Thanks
Ravikant
raavikant wrote:
Hi,
FME (Feature Manipulation Engine) by Safe Software, a highly versatile tool used for data conversion and manipulation, does not have a native connector or reader for Power BI.
FME provides support for a large number of data formats and systems, but Power BI is not directly among them. Power BI is largely a visualization and reporting tool, and it is not designed for other tools to reach in and pull data out of it.
However, you can look at alternate ways to extract data. You could potentially extract data from the same sources that Power BI is using. This is especially relevant if your Power BI data is being sourced from an SQL Server, Excel, or similar data sources, since FME has readers for these data sources.
If your data is directly in Power BI and you want to extract it to FME, you may need to explore other ways. One potential way would be using Power BI's export options to create a CSV, Excel, or other FME-readable file and then read that file using FME.
Thanks
Ravikant
Hi, that's not strictly true.
Power BI is ETL and visualisation. Power Query is the ETL engine.
You can use Power Automate to hook onto PBI datasets and process them.
Or you can use Paginated reports (essentially SSRS in the Power BI world) which can dynamically process data and email and/or save to network locations.
Power BI has now been re-branded as Microsoft Fabric which will give a significant capability all under one umbrella.
Reply
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.