How do I use ETL with Power BI Service (app.powerbi.com)?

[Anonymous]

I want to transform my data. I am attempting a simple field data type change in my simple CSV file from number to text. How do I do this with Power BI Service?

[v-yanjiang-msft]

Hi @Anonymous ,

Is your problem solved?? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,
Community Support Team _ kalyj

[v-yanjiang-msft]

Hi @Anonymous ,

Have your problem solved by @otravers 's suggestion?

Here're more detailed methods about this topic: ETL in Power BI, Using Dataflow, Power Query and ETL Tool

Power BI ETL with Dataflows: 4 Easy Methods

Best Regards,
Community Support Team _ kalyj

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

[otravers]

ETL in the Power BI service is done in dataflows using Power Query Online (you can copy/paste queries from Power Query in Excel or Power BI Desktop):

https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-introduction-self-serv...

[OscarTh]

You can build ETL pipelines in Power BI Service using dataflows or external tools like Azure Data Factory to handle heavier transformations. For a clear explanation of different ETL approaches in Power BI, I found this blog post really helpful - it walks through practical ways to manage extract, transform, and load steps without heavy coding.