What Does XMLA Endpoints Mean for Power BI and How to Test it for Free?
XMLA endpoint connectivity for public preview has been announced late March 2019. As at today, it is only available for…
Archive
Category: Excel
Quick Tips: How to Filter a Column by another Column from a Different Query in Power Query
A while ago I was visiting a customer that asked if they can filter a query data by a column…
Quick Tips: Time Dimension with Granularity of Seconds in Power BI and Analysis Services Tabular Models
In an article I posted a while back I showed different methods of creating Time dimension in Power BI and…
Exporting Data from Power BI Desktop to Excel and CSV – Part 2: Importing Power BI Data Directly to Excel
Update 2021 March: You can now export the data direct from Power BI Desktop using my tool, Power BI Exporter.…