Understanding Power BI Endpoints
In its early days, Power BI introduced an endpoint to support Analyze in Excel (AIXL). Later, the “Power BI datasets” connector relied on this endpoint to support connecting to published […]
Author Archive for: Prologika
Entries by Prologika - Teo Lachev
Updated Export Settings
A Happy Thanksgiving to all of you! I’m thankful for your interest in and support of my work. I’m glad that Microsoft has recently updated the Power BI tenant export […]
Power BI Dynamic M Query Parameters – Another Opportunity Missed for DirectQuery Users
UPDATE 17-Feb-2022: Dynamic query parameters now support popular relational data sources, and I posted an updated blog. I had recently a Power BI advisory engagement for a large ISV. They […]
Stop Using the Power BI Folder Connector
I know that it’s tempting to use the Folder connector to combine multiple files with the same schema and load them in Power BI Desktop with a few clicks – […]
Power Query Merging on GUID Columns
Scenario: You are merging two tables in Power Query on GUID columns with Text data type. In my case, the first table (UserDim) came from Azure SQL DB and the […]
Solving Configuration Errors with ADF Self-hosted IR
You’ve set up the Azure Data Factory self-hosted integration runtime to access on-prem data sources. You create a linked server, click Test Connection, and then get greeted with an error […]
Atlanta MS BI and Power BI Group Meeting on October 5th
Please join us online for the next Atlanta MS BI and Power BI Group meeting on Monday, October 5th, at 6:30 PM. Paco Gonzalez (CEO of SolidQ) will present and […]
Prologika Newsletter Fall 2020
Cloud deployments are the norm nowadays for new software projects, including BI. And Azure Synapse Analytics shows a great potential for modern cloud-based data analytics platform. Here are some high-level […]
Organizational Semantic Model
I am delivering a data governance assessment for an enterprise client. As a part of the effort to migrate reporting from MicroStrategy to Power BI, the client wants to improve […]
Section Hiked A.T. in Georgia
My wife and I started section hiking the Appalachian Trail during weekends to escape the summer heat and the virus. A.T. runs for 2,200 miles from Georgia to Maine, with […]
Follow Us
Prologika is a boutique consulting firm that specializes in Business Intelligence consulting and training. Our mission is to help organizations make sense of data by applying effectively BI technologies.
