Forum Discussion
Liveconnection to Dataset from PowerBI Desktop
rubayatyasmin
Can you may send me some Pictures for Point 1 and 2. I dont find such settings in my tenant.
Point 3: I use the July 2023 version.
Point 1 (sorry german) no Dataset Setting in the workspace settings:
Point 3 no possibilty to set up the things you mentioned:This document will guide you.
https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-connect-tools
Community ChampionHi, Pokke
Based on the error message you are seeing, it seems that you are either lacking the correct permissions, or the feature to establish a Live Connection to datasets in the Power BI Service is turned off.
Since you mentioned that you are the admin, have all the rights to the dataset, and can create reports in Power BI Service, the issue may not be about your permission. Also, there is no specific admin setting that prohibits live connections to datasets.
Here are a few suggestions to resolve the issue:
Check Workspace Settings: In the Power BI service, go to the workspace containing your dataset. Click on the '...' (More options), and select Workspace settings. Ensure that the 'Members can create and update live datasets' is checked under the 'Datasets' tab.
Ensure Correct Power BI Version: Make sure you are using the latest version of Power BI Desktop. Older versions may not support some features.
Validate Dataset Configuration: Ensure the dataset you are trying to connect to is configured to allow live connections. In the Power BI service, go to the settings of the dataset and verify that 'Allow live connection' and 'Allow XMLA endpoints and Analyze in Excel' are both enabled.