Forum Discussion
Prepare / transform data in Power BI
Hi Anonymous
One thing for sure is whatever you can do with MS Access you can do it with Power Bi and even more. So if you have Queries to control your data in Access then you can create formulas to control it in Power Bi using DAX. Also you can use Power Query in Power bi to Either control or add a conditionnal column to transform or format your columns.
For sure there are ways, but all depends on your model.
Hi Anonymous ,
Do you want to change the data type of the data from Access in Power BI? If yes, you can refer the following blog to get it.
Change Data Types of a Column in Power BI
In addition, the following documentations lists some general data transformations that can be done in Power Query. You can refer to them for some processing of your data.
Shape and combine data in Power BI Desktop
Common Data Transformations in Power Query
Best Regards
Hi Anonymous ,
Do you want to change the data type of the data from Access in Power BI? If yes, you can refer the following blog to get it.
Change Data Types of a Column in Power BI
In addition, the following documentations lists some general data transformations that can be done in Power Query. You can refer to them for some processing of your data.
Shape and combine data in Power BI Desktop
Common Data Transformations in Power Query
Best Regards