Thank you for posting query in Microsoft Q&A Platform.
You can consider having Synapse pipelines which are similar to ADF pipelines to take data from your source. Inside the pipelines you can consider having Synapse notebooks to transform your data and finally load the transformed data in to Synapse SQL tables. And then finally PBI can consume data from there.
Hope this helps. Please let me know if any further queries.
Please consider hitting
Accept Answer button. Accepted answers help community as well.