In one of my previous blog post, I described an approach to load text files from Azure Data Lake Store to Power BI filtered by the date period specified by users through setting the period start and period end parameters. That approach is capable to load text files located at the same folder. However, there … Continue reading Power Query – Parameterised Files Loading from a Year-Month-Day folder Hierarchy
Tag: Power Query
Power Query – Extract Multiple Tags Stored in a Single Text Field
Problem It is not rare to see that multiple attributes are stored in a single text field especially for tagging enabled applications where an unfixed number of tags may associated with an article or post. Those tags are often stored in a single text filed with a delimiter to separate them. When reporting, we often … Continue reading Power Query – Extract Multiple Tags Stored in a Single Text Field
Power Query – Parameterised Files Loading from Azure Data Lake Store within a Given Date Range
Power BI now supports data load from Azure Data Lake Store. We can connect to a folder in the Azure Data Lake Store and load all files from that folder. However, we often don't want to or aren't able to load all the files in the Azure Data Lake Store folder into Power BI due to … Continue reading Power Query – Parameterised Files Loading from Azure Data Lake Store within a Given Date Range
Inspecting SharePoint Metadata using Power Query
Power Query is a self-service ETL tool from Microsoft which is able to extract data from a broad range of data sources, transform the data, and finally load the data to PowerPivot. However, I have recently found that Power Query could also be a very handy SharePoint Metadata viewer to inspect the schema of SharePoint sites, lists, content … Continue reading Inspecting SharePoint Metadata using Power Query
Data Ninjago (Finsight-Tech Blogs) 
You must be logged in to post a comment.