Is anybody can guide me how to use Data Lake Gen2 from Power BI Desktop ?
On the URL, which part of the URL I should key in and how to bring all those files so that we can use it inside Power BI Desktop ? and threat those files as tables so we can create Data Model after it.
Sorry for this many question for start.
Thanks in advance.
>>I want to connect it directly in Power BI Dekstop, so not from Power BI Services Data Flow.
AFAIK, power bi desktop already supports the azure data lake gen2 connector, you can use this to directly get data from your data sources.
>>But I do want to import it one time only. So Get Data one time only to import all those files and be a separate Tables each in Power BI Desktop,
In fact, your scenario not able to directly get data and split them to subquery form on data source. Power bi gets data step will auto-create multiple query tables if you choose multiple target tables.(duplicate connector data step and navigation to specific target data tables)
Your scenario needs to further analyse and recognize the contents of table records. I'd like to suggest you create a main table to navigation to the sub-level, then you can create query tables to 'reference' main table and add custom navigation step to point to corresponding data tables.
@VoltesDev , refer to these
I found that also, but first of all, I want to connect it directly in Power BI Dekstop, so not from Power BI Services Data Flow.
The 2nd link is almost near, but it suggested me to click the binary, which is fine if we have only 1 TXT file, but I have more than 10, it is looks tedious since it is mean when click Binary at one line means it only imported 1 (table) only. Then I have to re-do to connect again and click Binary for the 2nd row which means 2nd table... and so on. Means 10 files, then 10 repeating actions.
The 3rd link is not suitable for me as it is to Combine all the files, which in my case, I need to have it separated as they were. Each files served it own purposes and have it own structure.
Thanks, but I don't want to Combine.
But I do want to import it one time only. So Get Data one time only to import all those files and be a separate Tables each in Power BI Desktop,
Check out new user group experience and if you are a leader please create your group!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Click here to read more about the July 2021 Updates
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps