You can create a staging area on database - db, so that you can do your transformation before loading into power bi
or I prefer you use the
1 - Create a flow to extract the data and convert to CSV and store in a SharePoint folder
2 Likes