cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
myrkur23
New Member

Data Transformation in Power Bi Service

Hi

I used power bi query in power bi desktop for data transformation but now I need to make  some dashboards in power bi service however I don't know how I can transform my data before loading them to power bi for visualization since power bi service deosn't have power bi query and I don't want to transform data locally and then upload it to power bi service. Is there a way to transform data based on a set of instructions/code so that every time data update, it applies those instructions/code on the data automatically before using it for visualization?

Thanks a lot

1 ACCEPTED SOLUTION
v-luwang-msft
Community Support
Community Support

Hi @myrkur23 ,

Power BI Service doesn't support to Data Transformation.

 

It is a cloud-based service. It supports light report editing and collaboration for teams and organizations. You can connect to data sources in the Power BI service, too, but modeling is limited.

 

For more details about the differences between Power BI Desktop and Power BI Service, please refer to this document: Comparing Power BI Desktop and the Power BI service - Power BI | Microsoft Docs.

 

For your requirements, please check if dataflow could help.

 

 

Dataflows are designed to support the following scenarios:

  • Create reusable transformation logic that can be shared by many datasets and reports inside Power BI. Dataflows promote reusability of the underlying data elements, preventing the need to create separate connections with your cloud or on-premise data sources.

  • Expose the data in your own Azure Data Lake Gen 2 storage, enabling you to connect other Azure services to the raw underlying data.

  • Create a single source of the truth by forcing analysts to connect to the dataflows, rather than connecting to the underlying systems, providing you with control over which data is accessed, and how data is exposed to report creators. You can also map the data to industry standard definitions, enabling you to create tidy curated views, which can work with other services and products in the Power Platform.

  • If you want to work with large data volumes and perform ETL at scale, dataflows with Power BI Premium scales more efficiently and gives you more flexibility. Dataflows supports a wide range of cloud and on-premise sources.

  • Prevent analysts from having direct access to the underlying data source. Since report creators can build on top of dataflows, it may be more convenient for you to allow access to underlying data sources only to a few individuals, and then provide access to the dataflows for analysts to build on top of. This approach reduces the load to the underlying systems, and gives administrators finer control of when the systems get loaded from refreshes.

Once you’ve created a dataflow, you can use Power BI Desktop and the Power BI service to create datasets, reports, dashboards, and apps that leverage the Common Data Model to drive deep insights into your business activities. Dataflow refresh scheduling is managed directly from the workspace in which your dataflow was created, just like your datasets.

 

Reference: 

Creating a dataflow - Power BI | Microsoft Docs

Configure and consume a dataflow - Power BI | Microsoft Docs

 

 

Best Regards

 

View solution in original post

2 REPLIES 2
v-luwang-msft
Community Support
Community Support

Hi @myrkur23 ,

Power BI Service doesn't support to Data Transformation.

 

It is a cloud-based service. It supports light report editing and collaboration for teams and organizations. You can connect to data sources in the Power BI service, too, but modeling is limited.

 

For more details about the differences between Power BI Desktop and Power BI Service, please refer to this document: Comparing Power BI Desktop and the Power BI service - Power BI | Microsoft Docs.

 

For your requirements, please check if dataflow could help.

 

 

Dataflows are designed to support the following scenarios:

  • Create reusable transformation logic that can be shared by many datasets and reports inside Power BI. Dataflows promote reusability of the underlying data elements, preventing the need to create separate connections with your cloud or on-premise data sources.

  • Expose the data in your own Azure Data Lake Gen 2 storage, enabling you to connect other Azure services to the raw underlying data.

  • Create a single source of the truth by forcing analysts to connect to the dataflows, rather than connecting to the underlying systems, providing you with control over which data is accessed, and how data is exposed to report creators. You can also map the data to industry standard definitions, enabling you to create tidy curated views, which can work with other services and products in the Power Platform.

  • If you want to work with large data volumes and perform ETL at scale, dataflows with Power BI Premium scales more efficiently and gives you more flexibility. Dataflows supports a wide range of cloud and on-premise sources.

  • Prevent analysts from having direct access to the underlying data source. Since report creators can build on top of dataflows, it may be more convenient for you to allow access to underlying data sources only to a few individuals, and then provide access to the dataflows for analysts to build on top of. This approach reduces the load to the underlying systems, and gives administrators finer control of when the systems get loaded from refreshes.

Once you’ve created a dataflow, you can use Power BI Desktop and the Power BI service to create datasets, reports, dashboards, and apps that leverage the Common Data Model to drive deep insights into your business activities. Dataflow refresh scheduling is managed directly from the workspace in which your dataflow was created, just like your datasets.

 

Reference: 

Creating a dataflow - Power BI | Microsoft Docs

Configure and consume a dataflow - Power BI | Microsoft Docs

 

 

Best Regards

 

Shahfaisal
Solution Sage
Solution Sage

Did you consider using Dataflows in Power BI Service? https://www.youtube.com/watch?v=t0PmkXlpv_Q

 

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.