Jared Westover doesn’t want to share:
Users want to pull data from tables in an Azure SQL database into Excel via Power Query. This situation sounds simple. However, I don’t want to provide direct access to the database for several reasons, including the potential governance and permissions nightmare. We have a Fabric workspace, and most of the data already exists in Power BI reports. How can we give users access to the data they need without providing direct access to the database for an easy SQL export to Excel?
Click through for the answer. This solution is a bit more roundabout than granting direct database access, but also comes with a host of security benefits.