Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
elaj
Helper IV
Helper IV

power bi desktop not able to connect to power bi-datasets

Hi, i am not able to connect to a Power BI-Dataset.

if i click this:

image.png

i get this window:

image.png

and nothing happens... i waited 5 mins... and nothing happens.

is something wrong with the service?

I have a Testaccount and i have 50 days left.

 

thanks for help 🙂

5 REPLIES 5
v-alq-msft
Community Support
Community Support

Hi, @elaj 

 

I'd like to suggest you check the following limitations and considerations.

  • Only users with Build permission for a dataset can connect to a published dataset using the Power BI service live connection.
  • Free users only see datasets in their My Workspace and in Premium-based workspaces.
  • Since this connection is a live connection, left-navigation and modeling are disabled. You can only connect to one dataset in each report. This behavior is similar to the behavior when connected to SQL Server Analysis Services.
  • Since this connection is a live connection, row-level security (RLS) and other such connection behaviors are enforced. This is the same as when connected to SQL Server Analysis Services.
  • If the owner modifies the original shared .pbix file, the dataset and report that is shared in the Power BI service is overwritten. Reports based on that dataset aren't overwritten, but any changes to the dataset are reflected in the report.
  • Members of a workspace can't replace the originally shared report. Attempts to do so result in a warning that prompts you to rename the file, and publish.
  • If you delete the shared dataset in the Power BI service, then other reports based on that dataset will no longer work properly or display their visuals.
  • For Content Packs, you must first create a copy of a content pack before using it as a basis for sharing a .pbix report and dataset to the Power BI service.
  • For Content Packs from My Organization, once copied, you can't replace the report created on the service or a report created as part of copying a Content Pack with a live connection. Attempts to do so result in a warning that prompts you to rename the file, and publish. In this situation, you can only replace published live connected reports.
  • Deleting a shared dataset in the Power BI service means no one can access that dataset any longer from Power BI Desktop.
  • Reports that share a dataset on the Power BI service don't support automated deployments using the Power BI REST API.

 

For further information, please refer to the document .

 

Best Regards

Allan

 

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

Yea @v-alq-msft  i know i read this list somwhere else.

I am the owner of the dataset and i published it into the workspace.

I have a pro testaccount... so i should have the pro functionallity.

 

When i want to open the connect to a power BI dataset dialog, this window opens.. and nothing else.. i have to close it by task manager. Even if i wouldnt have access to one Dataset. There should be a window, wich has an empty list. and i could click on cancel to cancel this dialog.

Ok,

 

now i published the dataset on my own workspace and i can connect to it.

So if you dont have any data you can connect to, you have that problem with the window to only be able to shut it down by task manager.

 

But why am i not able to live connect to the dataset i published by myself at the workspace of my company?

I have the permission to read, share and build.

do i have to upgrade the workspace?

 

not possible:

 

this is the message:

 

Fehler beim Upgrade des Arbeitsbereichs.
Überprüfen Sie die technischen Details, um weitere Informationen zu erhalten. Geben Sie diese Details an, wenn Sie sich an den Support wenden.
Zugrunde liegender Fehler: UnknownError
Aktivitäts-ID: 5f2401dd-4e87-40e0-b1a7-cf568f5573f5
Korrelations-ID: dbc15305-cd15-6a01-da20-003b101e62a7
Anforderungs-ID: 1f89ea81-3537-ed8e-39fb-6d4e092d5fb8
Zeit: Thu Jun 25 2020 18:27:59 GMT+0200 (Mitteleuropäische Sommerzeit)
Dienstversion: 13.0.13599.209
Clientversion: 2006.2.01600-train
Cluster-URI: https://wabi-west-europe-d-primary-redirect.analysis.windows.net/

the workspace i want to work in is a team created in teams.

I think I dont have the functionality to live connect to a dataset which exists inside of a "team-workspace"?

 

i come to the conclusion it is not possible. 🙂

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.