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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
davekerby
Helper II
Helper II

Connecting to Power BI Service dataset

When i connect to a dataset in power bi service via power bi deskop i can see im connected but cant view and of the fields. Any ides why?

 

 

 

 

 

8 REPLIES 8
s_w
Regular Visitor

Same problem here. For us, it seems related to an individual having limited access. There are a couple of fields that the person in question is not allowed to see. Maybe this crashes the process that is responsible for retrieving the field list?

s_w
Regular Visitor

We've confirmed that this is due to a user belonging to a role that has custom cell data read permissions in SSAS. We have a measure that contains salary data and is only available for certain indivuals. The settings in SSAS are as follows

 

Cell Data Restriction Settings

 

Does anyone have any advice on how we can fix this issue? It seems to be a bug in PowerBI, given that it works perferctly fine in Excel.

 

 

 

v-ljerr-msft
Microsoft Employee
Microsoft Employee

Hi @davekerby,

 

Since this is a live connection, left-navigation(Data view and Relationships view) and modeling tab are disabled, similar to the behavior when connected to SQL Server Analysis Services.

 

In this preview release of the Power BI service live connection, there are a few limitations and considerations to keep in mind. Smiley Happy

  • Only users who are part of the same Power BI service workspace can connect to a published dataset using the Power BI service live connection. Users can (and often do) belong to more than one workspace.
  • Since this is a live connection, left-navigation and modeling are disabled, similar to the behavior when connected to SQL Server Analysis Services.
  • Since this is a live connection, RLS (row- and role-level security), OneDrive for Business, and other such connection behaviors are enforced, just as they are when connected to SQL Server Analysis Services.
  • When selecting which dataset to connect to in the Power BI service, the search box only applies to workspaces that have been expanded.
  • If you modify the original shared .pbix file, the dataset and report that is shared in the Power BI service is overwritten.
  • You cannot 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 Power BI Desktop (.pbix files) 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 cannot replace the report created on the service and/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.
  • When you create a report based on dataset using a live connection to the Power BI service, you can only publish that report to the same Power BI service workspace that contains the dataset being used.
  • Deleting a shared dataset in the Power BI service means you can no longer access that dataset from Power BI Desktop.


 

Regards

I am having the same issue, and my reports will not refresh against that dataset.  No error message.

Untitled.gif

 

 

 

Hi,

 

this is what im currently seeing, Its connected to the Power Bi Service data set but i see no fields.

 

 

 

 

 

 

 

 

 

 

 

 

 

Hi @davekerby,

 

I just verified that the Power BI Service connector works all fine on my Power BI Desktop(2.47.4766.801 64-bit (June 2017))?

 

What version of Power BI Desktop are you using? What's the data source of your original dataset on Power BI service?

 

Regards

The desktop version im using is Version: 2.47.4766.801 64-bit (June 2017) which is the same as you.

 

the datasource is of the dataset is text files and CSV

I am having the same issue, and my reports that are connected to the dataset will not refresh.  No error, it just gives me a continous circle.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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