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
Azure_newbie
Helper I
Helper I

How to know a dataset's type and path without the permission?

I am quite new to Power BI. Recently I need to update a Power BI report, when I open the pbix file I got  "Looks like we're unable to access the dataset. Please contact the owner of the dataset." 

 

I understand it is a live connection to the dataset and I need to request for permission. My question is how can I find the data type (SQL, SharePoint or Datalake?) and the path (the server name, URL, etc). I need these information so that I can request for permission.

 

Thanks for advising. 

1 ACCEPTED SOLUTION

Hi @Azure_newbie ,

 

As far as I know, you can find the data source in Data source setting.

File > Option and settings > Data source settings

vrzhoumsft_0-1691478925292.png

Above is my data source, a Power BI Dataset named "Rank in Direct Query to sort". Click on Change Source to see determind the workspace. You need to make sure you account has the access to this dataset or you could only know the dataset name.

Then you can sign in your Power BI account in Power BI Service and look for this Dataset in Workspace.

 

Best Regards,
Rico Zhou

 

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

 

 

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@Azure_newbie , That is Power BI Dataset, so all the information will there in power bi dataset. even if you get access as dataset you will not be able to see that

 

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

 

Dataflows and Dataset Design Pattern implementation: https://youtu.be/zwhJ1hWPcrA

Thanks for you reply.

I managed to get sign-in to the admin account and open the report. The "Data view" is missing I think it is correct since it is a direcy query report.

I want to update the dataset (add column and update query). But I cannot find a way to do so. Could you please point me the steps? Sorry for the newbie question. 

 

I found this discussion (Solved: Editing Datasets With Direct Query - Microsoft Fabric Community) it seems edit datasets is impossible? It seems strange to me. I cannot update the dataset?

Hi @Azure_newbie ,

 

As far as I know, you can find the data source in Data source setting.

File > Option and settings > Data source settings

vrzhoumsft_0-1691478925292.png

Above is my data source, a Power BI Dataset named "Rank in Direct Query to sort". Click on Change Source to see determind the workspace. You need to make sure you account has the access to this dataset or you could only know the dataset name.

Then you can sign in your Power BI account in Power BI Service and look for this Dataset in Workspace.

 

Best Regards,
Rico Zhou

 

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

 

 

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.