Integrating data platform to Power BI

[Bhaskar_1]

Our product, XYZ, serves as an ETL platform that seamlessly integrates with diverse data platforms (such as SQL DB, NoSQL DB, JSON files, etc.) to aggregate and transform data. Presently, our aim is to link the transformed data from XYZ with Power Bi for effective visualization. Can you advice the most effective approach for this?

[Anonymous · Accepted solution]

Hi @Bhaskar_1 ,

Here's a tutorial on connecting XYZ to Power BI, you can check it out for detailed steps.

Lab 1: GET & TRANSFORM Data – Data Visualization Labs (pressbooks.pub)

You can also use import Dataverse data by using the Dataverse connector: This method caches (stores) Dataverse data in a Power BI model. It delivers fast performance thanks to in-memory querying. It also offers design flexibility to modelers, allowing them to integrate data from other sources. Because of these strengths, importing data is the default mode when creating a model in Power BI Desktop.

Power BI modeling guidance for Power Platform - Power BI | Microsoft Learn

How to Get Your Question Answered Quickly 

If I have misunderstood your meaning, please provide more details.

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Harpreet1405_12]

Hello,

I want to create a SharePoint page or website where I can display all dashboard visualizations. The data will come from different sources such as Excel, Word documents, the cloud, and OneDrive. How can I create a dataset in such a way that it is centralized in one place and create live dashboards?

How can I create a dynamic website of dashboards?

Thank you.