Hi, First post here.
I plan on using Power Automate to update a Power BI dataset when a SharePoint file is updated. The only issue I have is that the SharePoint excel file I will be working with needs to be edited before the refreshing of the dataset. A single column in the excel sheet needs to be changed from 'General' to 'Text'.
Is there a way to automate this and remove the manual process?
Thanks a lot