fabric data warehouse

What happens if you try the following:

1. In your Fabric workspace, click on the ... symbol next to your Warehouse.

2. Select 'Copy SQL connection string'. 

3. Click Copy

4. Create a new report (Blank report) in Power BI Desktop.

5. In Power BI Desktop, click SQL Server

6. Paste the SQL Connection String and click OK

7. Are you able to select the warehouse from the Navigator? 

If not, sounds like there is an issue/bug or lack of permission.

Another thing you could try:

1. Create a new report (Blank report) in Power BI Desktop

2. Create a Blank Query

3. Click Advanced Editor

4. Remove all code contents and paste the following code (insert your specific details):

let
    Source = Sql.Databases("//INSERT YOUR SQL CONNECTION STRING HERE//"),
    Warehouse = Source{[Name="//INSERT YOUR WAREHOUSE NAME HERE//"]}[Data],
    Table = Warehouse{[Schema="dbo",Item="//INSERT YOUR TABLE NAME HERE//"]}[Data]
in
    Table

5. Then click Done.

This should connect to your table in the Fabric Data Warehouse if you have access.

To check if permission / using wrong user is the issue, then you could select Data source settings:

Select the connection to your Fabric Workspace / Data Warehouse.
Click "Clear Permissions".

Confirm by clicking "Delete".

Click "Refresh Preview":

Click "Edit credentials":

Select "Microsoft account" and "Sign in":

Then sign in with the same user account which has access to the data warehouse in the Fabric workspace.

Afterwards, click "Connect".

If that doesn't work, and you know that the user has the necessary permission level to the Fabric workspace / data warehouse, then it sounds like an issue/bug.