I have a cosmos DB as a source, which I am accessing the data by using in a Synapse and storing the data in a data lake. I want to visualize this data in a Power BI. So my question is what approach will be best
1. Access Blob storage data directly into the Power BI by using power BI's own Connector
2. Access Blob storage data in a synapse and then connect it to the Power BI by integrating power BI in a Synapse?
Also if i want to use the delta load(Incremental dataset) shall I do it in a blob storage by creating a pipeline or Do it in a power BI as data size is small?