PowerBI (DirectQuery): User cannot see the visual

[marlovobook]

Dear All,

I create views on Lakehouse and use those views to make visualization on PowerBI (DirectQuery); howerver, users cannot see the visualization I have made.

One way is to give users the access to SQL Analytics Endpoint for that Lakehouse.

Any better solutions as I don't want the users to be able to access SQL Endpoint?

Best,

[Anonymous]

Hi @marlovobook ,

Based on the description, it should using the SQL endpoint to see the visual. 

SQL analytics endpoint is a warehouse that is automatically generated from a Lakehouse in Microsoft Fabric.

The SQL analytics endpoint is read-only, and data can only be modified through the "Lake" view of the Lakehouse using Spark.

But may be you can set object level security for accessing data using SQL endpoint. Setting workspace roles and permissions.

You can also view the following documents to learn more information.

What is the SQL analytics endpoint for a lakehouse? - Microsoft Fabric | Microsoft Learn

Workspace roles and permissions in lakehouse - Microsoft Fabric | Microsoft Learn

Lakehouse tutorial - Build a report - Microsoft Fabric | Microsoft Learn

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Direct Query only works with SQL based data sources.