Find all data sources in published Power BI reports

[tracyhopaulson]

Hello,

Is there a way to identify every data sources used in all published Power BI reports in my organization?

[v-pnaroju-msft]

Hi tracyhopaulson,

Thank you for your update. We understand that you are currently unable to view the OneLake Catalog as described.

It is possible that OneLake has not been configured in your organisation. Typically, administrators need to enable OneLake before it becomes accessible in the Power BI service.

We recommend that you contact your IT team to verify whether OneLake has been set up for your organisation. They will be able to provide further assistance in enabling this feature.

Once enabled, the OneLake Catalog should be visible as shown in the screenshots below:

If you find our response helpful, we request you to mark it as the accepted solution and provide kudos. This will assist other community members facing similar queries.

Thank you.

[tracyhopaulson · Accepted solution]

We are not on a cloud based yet so this explains I don't see anything in OneLake. I guess we can close this discussion and I will continue to hunt for other solution.

[v-pnaroju-msft]

Hi tracyhopaulson,

Please find below an alternative solution along with the steps that may assist in resolving the issue:

Power BI provides a feature known as the OneLake Catalog, enabling users to discover existing data and reports within their organization.

1. Navigate to the Power BI service and select OneLake from the navigation pane.
2. Open the OneLake Catalog, where you will find a list of data items accessible to you. You can filter this list to display all items, your own items, or those endorsed by others within your organization.
3. By exploring the datasets and reports available in the OneLake Catalog, you can review their details to gain insights into the data sources they utilize.

This approach offers a user-friendly interface for exploring and identifying data sources without requiring scripting or advanced technical expertise.

Additionally, please refer to the following link for further information:

Data sources for the Power BI service - Power BI | Microsoft Learn

If you find this response helpful, kindly mark it as the accepted solution and provide kudos. Your acknowledgment will assist other community members facing similar queries.

Thank you.

[tracyhopaulson]

Looks like OneLake is not set up since I do not see the list that you described.

[v-pnaroju-msft]

Hi tracyhopaulson,

We wanted to check in regarding your query, as we have not heard back from you. If you have resolved the issue, sharing the solution with the community would be greatly appreciated and could help others encountering similar challenges.

If you found our response useful, kindly mark it as the accepted solution and provide kudos to guide other members.

Thank you.

[v-pnaroju-msft]

Hi tracyhopaulson,

We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.

If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.

Thank you.

[tracyhopaulson]

It is not resolved yet. I read the suggested method using Power BI REST APIs but it's too technical for me to follow. Still looking for other method maybe with third party software, etc...

[v-pnaroju-msft]

Thankyou, @Deku, for your response.

Hi @tracyhopaulson,

We sincerely appreciate your inquiry on the Microsoft Fabric Community Forum.

In addition to the response provided by @Deku , please refer to the following methods that may assist in resolving the issue:

1. Administrators can navigate to the Power BI Admin Portal and access the Datasets to review data source details. This method offers a user-friendly interface for monitoring data sources without requiring scripting.

2. For a smaller-scale solution, each Power BI report can be manually inspected in Power BI Desktop to view its data sources. While this approach is not scalable for large organisations, it can be useful for ad hoc verifications.

If you find our response helpful, we kindly request you to mark it as the accepted solution and provide kudos. This will assist other community members who may have similar queries.

Thank you.

[Deku]

Scanner API or GetDatasourcesAsAdmin

Please see this similar forum post