Forum Discussion
Import data with multiple levels
Hi sengyap,
>>When I import my data, my "country" data cannot be broken down into the respective countries, such as Indonesia, Cambodia.
Did you make sure the country field's data category is correctly identified to city or state or province?
If not, you should manual modify it.
In addition, you should drag your "geography" column to legend file to group the data.
>>Also, how was he able to connect to so many datasets in a single report?
You can use get data button to add multiple datasource which from different place.
Regards,
Xiaoxin Sheng
Dear Xiaoxin_Sheng,
Thank you for replying.
I am using Power Bi service, not Power Bi desktop. Does it allow me to modify my country field's data category to city or state or province?
After I import the data sources using "get data", how do I use the data sources for my report? I am only able to use one data source per report.
Regards,
Seng Yap
Hi sengyap,
>>After I import the data sources using "get data", how do I use the data sources for my report? I am only able to use one data source per report.
Based on research and test, It is impossible to use multiple datasource on service, perhaps you can edit on desktop and publish to service.
Regards,
Xiaoxin Sheng