I have recently created a dataflow retrieving data from an excel file that is located in a Teams Sharepoint Site.
I use power bi desktop to connect to the dataflow and it works perfectly for me (i am the owner).
However, other team members cannot view the tables when they connect with their desktop app. They see the path but at the final level when you are select tables it is empty.
I have also changed the data source credentials to be on Sharepoint using my organization authentication and the privacy level to be organizational.
I have asked them to clear permissions and try again but still nothing shows up (Solution to this issue https://community.powerbi.com/t5/Desktop/Dataflow-No-table-show-up-in-Desktop/m-p/1033800#M486458)
Thanks in advance for your help,
Please check if the dataflow is stored in Azure Data Lake Storage Gen2 account,,see: https://docs.microsoft.com/en-us/power-bi/desktop-connect-dataflows#considerations-and-limitations-1
@v-qiuyu-msft thanks for your swift reply. Looking into it with someone from the power bi admin team and i will get back to you