Unable to view the data in power BI dashboard

[kasun_rumesh]

My organization is using a Fabric F2 license. We have a dashboard connected to the Fabric data warehouse as SQL Server using the DirectQuery method. However, when I try to provide dashboard access to users through the Power BI server, they are unable to view the data.

After the clicked the "see details"

A connection could not be made to the data source with the Name of '{"protocol":"tds","address":{"server":"[Server]"","database":"[WarehouseName]"},"authentication":null,"query":null}'.

I have tried multiple approaches:

   1. Published to the same workspace and shared the dashboard.
   2. Published to a different workspace and shared the dashboard.
   3. Published to my personal workspace and shared the dashboard.
However, I still encounter the same issue.

The Fabric license is not assigned to my account, but I have admin rights. My account has a Power BI Pro license that we have purchased.

[AndyDDC · Accepted solution]

Hi @kasun_rumesh as you're using DirectQuery, any user opening a report will need read access to the underlying Warehouse.  I would suggest doing this by sharing the Warehouse to a group (with the relevant users in the group) and then specifying object level permissions. E.G:

• Hover over the Warehouse item in the Workspace view and select the elipsis
• Select Manage Permissions
• Click Add User
• You can then add the relevant users/groups
• Don't enable anything, this will give the users/group connect permissions only

In the Warehouse you can now run GRANT SELECT ON ....

E.G GRANT SELECT ON SCHEMA::DW TO users/groups.

Hope that helps.

For reference:

Security for data warehousing - Microsoft Fabric | Microsoft Learn

[Ruben-C1]

I have the same issue. However, I cant add user on the sql endpoint, I just can change it in the database. Do you know any way i can edit this

As you guys can see i am the owner

I cant add new people or edit my own profile

[Ruben-C1]

I have tried to connect to the sql database from microsoft fabric and it isnt helping at all. I have the same issues even though i have all the permissions

[kasun_rumesh]

@AndyDDC  Any other recomand way to connect to the power BI without using this method?

[AndyDDC]

With DirectQuery no as that will need to use pass-through authentication due to no support for SQL logins in Fabic Warehouse.

Are you able to add object level security to the Warehouse?

[kasun_rumesh]

No, I didn't. If i switched to Direct query to import what will be the limitaion and advantages that i have? 

[kasun_rumesh]

My organization is using a Fabric F2 license. We have a dashboard connected to the Fabric data warehouse as SQL Server using the DirectQuery method. However, when I try to provide dashboard access to users through the Power BI server, they are unable to view the data.

After the clicked the "see details"

A connection could not be made to the data source with the Name of '{"protocol":"tds","address":{"server":"[Server]"","database":"[WarehouseName]"},"authentication":null,"query":null}'.

I have tried multiple approaches:

   1. Published to the same workspace and shared the dashboard.
   2. Published to a different workspace and shared the dashboard.
   3. Published to my personal workspace and shared the dashboard.
However, I still encounter the same issue.

The Fabric license is not assigned to my account, but I have admin rights. My account has a Power BI Pro license that we have purchased.

[kasun_rumesh]

My organization is using a Fabric F2 license. We have a dashboard connected to the Fabric data warehouse as SQL Server using the DirectQuery method. However, when I try to provide dashboard access to users through the Power BI server, they are unable to view the data.

after they clicked the "see details"

A connection could not be made to the data source with the Name of '{"protocol":"tds","address":{"server":"[Server]"","database":"[WarehouseName]"},"authentication":null,"query":null}'.

I have tried multiple approaches:

   1. Published to the same workspace and shared the dashboard.
   2. Published to a different workspace and shared the dashboard.
   3. Published to my personal workspace and shared the dashboard.
However, I still encounter the same issue.

The Fabric license is not assigned to my account, but I have admin rights. My account has a Power BI Pro license that we have purchased.