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.
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:
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.
