topic Re: Unable to view the data in power BI dashboard in Data Warehouse

Unable to view the data in power BI dashboard

kasun_rumesh — Mon, 18 Nov 2024 16:42:29 GMT

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.

Re: Unable to view the data in power BI dashboard

kasun_rumesh — Mon, 18 Nov 2024 16:38:09 GMT

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:

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.

Re: Unable to view the data in power BI dashboard

kasun_rumesh — Mon, 18 Nov 2024 16:45:03 GMT

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:

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.

Re: Unable to view the data in power BI dashboard

AndyDDC — Mon, 18 Nov 2024 23:40:26 GMT

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

Re: Unable to view the data in power BI dashboard

kasun_rumesh — Tue, 19 Nov 2024 08:36:15 GMT

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

Re: Unable to view the data in power BI dashboard

AndyDDC — Tue, 19 Nov 2024 09:59:09 GMT

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?

Re: Unable to view the data in power BI dashboard

kasun_rumesh — Wed, 20 Nov 2024 03:26:49 GMT

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

Re: Unable to view the data in power BI dashboard

Ruben-C1 — Fri, 16 May 2025 01:18:48 GMT

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

Re: Unable to view the data in power BI dashboard

Ruben-C1 — Fri, 16 May 2025 02:31:34 GMT

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