Forum Discussion
Unable to Change Data Type of String in PowerBI - Dataset Published via Alteryx Power BI Output Too
Yes, the issue is now clear after reviewing the information provided by the contributors.
Since push datasets created through the REST API don’t support Power Query or transformations, the inability to change data types inside Power BI is expected behavior. Also, as confirmed, external tools like Alteryx cannot write directly into Dataflows because Dataflows do not expose a row-level write API.
At this point, it seems the only workable approach is to stage the data in an intermediate source such as Azure SQL, SharePoint/OneDrive, or Dataverse, and then use a Dataflow to perform proper transformations including DateTime conversion. We will explore these options on our side.
Thank you again for the clarification and guidance.
Community SupportHi Junaid46 ,
Has the issue been resolved on your end, or would you like us to provide more information? Please let us know if you need any assistance.
Yes, the issue is now clear after reviewing the information provided by the contributors.
Since push datasets created through the REST API don’t support Power Query or transformations, the inability to change data types inside Power BI is expected behavior. Also, as confirmed, external tools like Alteryx cannot write directly into Dataflows because Dataflows do not expose a row-level write API.
At this point, it seems the only workable approach is to stage the data in an intermediate source such as Azure SQL, SharePoint/OneDrive, or Dataverse, and then use a Dataflow to perform proper transformations including DateTime conversion. We will explore these options on our side.
Thank you again for the clarification and guidance.
- V-yubandi-msft
Good to hear the information helped and things are now clear.
Your idea to look into staging options like Azure SQL, SharePoint/OneDrive, or Dataverse, and then use Dataflows for transformations, is a strong and scalable strategy.
If you need more information or encounter any issues, feel free to reach out. We're here to support you and appreciate your active participation in the community.
Thank You.