It can sometimes be frustrating to work with slow data sources or complex Power Query queries in Power BI Desktop: you open the Power Query Editor, make some changes, click Close & Apply and then wait ...
If your business uses relational databases to store data, it helps to use the SQL SELECT command with the INTO clause to create new tables from query results. This method isn't ANSI-standard SQL, but ...
In the last two posts in this series I showed how removing columns from the tables used in a Power Query merge operation can improve refresh performance. In this post I’ll show you a different trick ...
Lineage, BigQuery - lineage from tables/views created via Terraform (REST API) is not being ingested
Metadata ingestion doesn't extract lineage from tables or views created via Terraform (that uses REST API) as DataHub can't find relevant logs in cloudaudit_googleapis_com_data_access table. Create ...
How to create and populate a table in Microsoft Excel’s Power Query Your email has been sent Updating data in a Microsoft Excel workbook is common, but you will run into cases where you can replace ...
How to query a LibreOffice database using the Query Design View Your email has been sent LibreOffice contains a very powerful database tool that is actually quite user friendly. Here's how to create a ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback