Power Query is Microsoft's data transformation and presentation engine. Thanks to it, services like Microsoft Power BI can focus on data visualization and let Power Query ETL the disparate data sources instead. Though, highlighting one often overlooked data source, Power Query can actually ETL data from PDFs. Similar to importing data from a CSV, select … Continue reading Power BI: Power Query | Import PDF Tables
Power BI
Power Query: Overview
The capabilities of the Power Platform wowed many organizations. Especially Power BI and its ability to extract, transform, and load (ETL) datasets from dozens of disparate data sources. At the same time, Microsoft Dataverse, the low-code data storage offering of the Power Platform, also supports ETL of disparate data sources. Though, this isn't unique to … Continue reading Power Query: Overview
Power Platform: Data Sources | SQL Tables or Dataverse Tables
The Power Platform is Microsoft's collective of no-code/ low-code solutions. To supplement this platform, Dataverse is Microsoft's secure, no-code/ low-code data storage solution. SQL Server is still a strong contender for data storage, but leveraging it requires some mastery of SQL. Dataverse, however, stores data in tables just like SQL, but doesn't require any proficiency … Continue reading Power Platform: Data Sources | SQL Tables or Dataverse Tables
Power BI: Dataset Intersect(s)
Power BI can pull in and analyze data from a variety of sources. And once loaded, Power BI will form data relationships wherever it can. Even so, new datasets are sometimes needed instead of data relationships. One way to create these new datasets is to use the INTERSECT() expression with dataset pairs. One business scenario, … Continue reading Power BI: Dataset Intersect(s)
Power BI: What If… Citizen Insights?
Microsoft is on a mission to empower everyone through technology. Whilst on this journey, they crafted the Power Platform and gave the world Power BI. At that moment, Microsoft empowered thousands of citizen developers to gather insights using their respective business datasets. Citizens could create richer data visualizations and analyze more data from varying sources... … Continue reading Power BI: What If… Citizen Insights?
Power Platform x SharePoint – Approval Requests: Part III (Power BI)
The Power Platform is a Microsoft offering of tools to help organizations meet challenges effectively. Among these tools, there are some notable standouts: Power Automate – Create automated business processes.Power Apps – Create custom forms and portals.Power BI – Create rich charts, graphs, etc. With their powers combined, one could easily build in-house solutions using … Continue reading Power Platform x SharePoint – Approval Requests: Part III (Power BI)
Power BI: Intersect w/ Netflix Viewing Data
Recap: Visuals were built in the previous Netflix Viewing Data blog, but no formulas. Still, presenting the year-to-year viewing counts in stacked bar charts was simple enough. And the drilldowns weren't bad... Note: The Netflix viewing history export only includes the first time something is viewed, not each time it is viewed. However, today I … Continue reading Power BI: Intersect w/ Netflix Viewing Data
console.log('Charles'); 