cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
PawelGM Frequent Visitor
Frequent Visitor

Power BI Desktop and Azure Blob - Column Names and Data Types in JSON, Data in CSVs

Hello All,

I am looking for a push in the right direction. I have a scenerio I can't seem to find online.

 

I connect Power BI Desktop to Azure Blob Storage (Data Lake) and I am easily able to find my Sales Cube, but the issue I have is that my column names, data types, etc. are in a model.json file, and my data is in CSVs.

 

All of the posts I find online for combining these files in Power Query deal with only same file types (CSVs) and the CSVs have headers that define column name and type. When I try to combine the json and csv, I obviously get an error.

 

I can fairly easily expand out the json to get the column names for a partical csv and use advanced query to rename the CSVs column names by doing a list to table from the expanded json, but getting data types becomes complex, and I am sure there are many other considerations down the road.

 

Is there an easier way to build tables where json holds all the model information and the CSVs just hold the data in generic columns?

 

Thank you in Advanced Datanauts!

DataNauts / SuperUsers

2 REPLIES 2
ThomasPBI Frequent Visitor
Frequent Visitor

Re: Power BI Desktop and Azure Blob - Column Names and Data Types in JSON, Data in CSVs

Hi PawelGM,

 

I have the same problem as you do. Sadly i dont even know how to "expand out the json to get the column names for a partical csv and use advanced query to rename the CSVs column names by doing a list to table from the expanded json". Are you able to help me out with a like or a quick how to guide?

 

PawelGM Frequent Visitor
Frequent Visitor

Re: Power BI Desktop and Azure Blob - Column Names and Data Types in JSON, Data in CSVs

Thomas,

 

This article helped me rename the columns from a table. The article solve my issue, and at this point I am just asking around for a more effecient way to accomplish the task, as I have many entities that need this procedure in a data warehouse:

https://community.powerbi.com/t5/Desktop/Auto-renaming-columns-based-on-value-in-another-table/td-p/...

 

I will try to do a walk thorugh if I have some spare time. Please check back soon.

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 317 members 3,322 guests
Please welcome our newest community members: