cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to connect to Power BI Service datasets from Power BI Desktop

Issue:

Unable to connect to Power BI Service datasets from Power BI Desktop

Error:

Cannot load model.We couldn't connect to model in Power Bl Service. The dataset may have been deleted, renamed or it is possible that don't have permission to it.No OLE DB Error Information found.

monaraya_0-1601874893975.jpeg

Possible Cause: 

The possible reasons for the above error could be: -

  1. The workspace in which the dataset resides is a V1 Workspace. For V1 workspace or classic workspace, only members of that workspace build reports on your dataset. If the dataset's build permission is explicitly added via methods mentioned here, the dataset would throw an error like above.
  2. An older version of Power BI Desktop. As of now, we do not see the issue in Sept, 2020 Desktop.
  3. Another possible reason could be RLS. Remove the RLS from the report or add the user in the RLS and check again. RLS can be identified if we collect a Fiddler trace and see error : "HTTP/1.1 500 Error in Convert model's roles to string" " in the Fiddler trace

Workaround:

To workaround the issue, try connecting to the dataset from Power BI service -> My workspace -> Get Dataset -> Published Datasets -> Choose the dataset

monaraya_1-1601874893989.png

Resolution:

  1. If we are using Classic workspace, add user as a Member of the workspace so that user can create a live connection to the dataset from Power BI Desktop
  2. Else, upgrade to V2 workspace and give the user build permission to the dataset
  3. Add user in RLS security of Power BI Service. The dataset owner should test the RLS security when trying to use it for the user. Reference: https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls#validating-the-role-within-the-pow...

s1.jpg

s2.jpgS3.jpgs4.JPG

Additional Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets#connect-to-...

s5.JPG

 

Author :Srishti Sharma

Reviewer: Mounika Narayana Reddy