How to connect OCDM dataset to Power BI? (Azure Data Lake Storage Gen2 set)

[techy7]

Hello, I recently got access to an OCDM dataset (One Commercial Data Model) but having a hard time connecting this data in Power BI.

I have a URL link to the data asset (Azure Data Lake Storage Gen2 resource set) and tried connecting to this using the Power BI connector but someone told me that I need to set up a Azure Databricks workspace to store data there, then connect it in Power BI. Is this the only way, or are there any alternativee ways I can directly connect to the OCDM dataset I got access to? 

First timer here so any advice would be greatly appreciated! 

Data Hierarchy: 

How it loads in Power BI. I can open these Binary/Parquet files but doesn't have the data I'm looking for. 

[v-jianpeng-msft]

Hi, @techy7 

To connect to Azure Data Lake Storage Gen2 from Power BI, you don't necessarily need to set up an Azure Databricks workspace. You can use the Azure Data Lake Storage Gen2 connector.

You can refer to the following articles:

Power BI with Azure Data Lake Storage Gen2 – Power BI Desktop & Service | Data Awareness Programme (...

You mentioned reading your Binary/Parquet file in Power Query and didn't find the data you need. You should make sure that your OCDM data is all stored in this file. There is no connector in Power BI that connects directly to OCDM. You can store your OCDM data in other repositories via ETL and then read the data from those repositories through Power BI.

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

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

[techy7]

Hi Thank you for your reply!! I tried the Azure Data Lake Storage Gen2 connector in Powre BI and tried loading the data, but it didn't really work. Although I can connect to the URL link of the data asset and click through "binary" it didn't give me the data & schema I was looking for.