Pardaan.com

If your work becomes your passion…

If your work becomes your passion…

Menu

  • Profile
  • Tags

Categories

  • Data & Analysis (248)
  • Dynamics NAV & BC (5,181)
    • Functional (119)
    • General (116)
    • Technical (48)
    • Tips & tricks (5,002)
  • ERP general (347)
  • Information management (58)
  • Off-topic (47)
  • Projectmanagement (450)
  • Quote of the week (29)
  • Visual C# / ASP.net (57)

Query Folding And Writing Your Own SQL Queries In Power Query/Power BI/Excel Get & Transform

By admin in Data & Analysis 20 June 2017

When you connect to a relational database like SQL Server in Power BI/Power Query/Excel Get & Transform you have two choices about how to get the data you need:

Bron : Chris Webb’s BI Blog
Lees meer…

Share this:

  • Facebook
  • LinkedIn
  • WhatsApp
  • Twitter
  • Email
  • Print

Like this:

Like Loading...

Gerelateerde artikelen:

  1. How To Tell Whether Query Folding Is Taking Place When Importing Data From Analysis Services In Power BI And Excel Power Query
  2. Power Query/Get & Transform: The Future Of Data Loading In Excel
  3. Improving The Performance Of Aggregation After A Merge In Power BI And Excel Power Query/Get&Transform
  4. Implementing Basic Query Folding On A Web Service In Power Query/M And Power BI
  5. “In the Previous” Date Filters In Power BI/Get&Transform/Power Query
Tags GetQuerySQLTransform
Reconciling the Dynamics NAV Inventory to G/L
Microsoft Data Insights Summit Videos Published

Related Articles.

D365 Business Central : Using Query to Get Distinct Values

10 Aug, 2022

Query Object: How Does It Work In Business Central?

12 Jul, 2022

Do you know what a QueryCategory is?

04 Jul, 2022

Export SQL data to CSV or XML File via Powershell

03 May, 2022

Get ID from Table

23 Mar, 2022
Pardaan.com

Microsoft Dynamics NAV, Business Central, ERP general, Projectmanagement, Information management and Visual C#


Dennis Pardaan

Facebook page

Facebook page

Stay Hungry, Stay Foolish

RSS Mibuso

  • Multiple nodes with same name
  • Ls Data Director
  • Purchase invoice with 0 cost and valid vat
  • [SOLVED] Report extentsion - RDLC layout modification
  • read Bridge weight
  • GuiAllowed - stop pop up message for dimensions when creating Job from AL
  • Replication from HO to a store
  • Creating empty container (CSIDE)
  • HideDialog When background process create pick list
  • convert pdf file to base64 string
  • Can I create a receipt/ticket printer report like in shops/supermarkets?
  • Business Central version 15 (On-premise) - Long Running Queries
  • User-defined views crashes client.
  • Deployment of app file to Dynamics BC OnPrem
  • Adding parameter to Report 292 Copy Sales Document
  • Parameters in the cloud
  • NAV 2017- Positive Pay Modifications
  • US Sales Tax
  • Database locks across instances (NAV 2017)
  • Dynamics NAV 2013 Generating a GS1 2D Matrix Barcode

RSS Dynamics NAV Team Blog

  • The AI-powered contact center, part 2: Achieve superior self-service voice support
  • Exchange Online Basic authentication is going away: What you need to know
  • Microsoft is a Leader in The Forrester Wave: CRM Suites, Q3 2022
  • The AI-powered contact center, part 1: Create engaging digital experiences
  • Supercharge your CRM with Microsoft Viva Sales—Now in preview
  • Strike a strategic inventory balance in your supply chain with demand driven material requirements planning (DDMRP)
  • Honor customer data use consent with unified profiles in Dynamics 365 Customer Insights
  • Introducing the Microsoft Digital Contact Center Platform: A comprehensive, flexible customer care solution
  • Modernize employee expense management with automation and AI
  • 2022 release wave 2 plans for Dynamics 365 and Power Platform now available 

RSS Power BI

  • Power BI paves the way for smooth Azure Analysis Services migrations
  • On-premises data gateway August 2022 update is now available
  • PostgreSQL connector for the virtual network data gateway
  • Power BI August 2022 Feature Summary
  • Announcing improvements to Datamart Query editor
  • Join us! 18-23 September 2022. The FIRST ever Microsoft Power Platform Conference!
  • Announcing: The Power BI app is available in Microsoft Teams Mobile
  • ADLS Gen2 and Azure Blobs SAS Key Connectivity
  • Analysis Services server properties in Power BI Premium are now in public preview
  • On-premises data gateway July 2022 update is now available
Proudly powered by WordPress. Theme: DW Minion by DesignWall.
%d bloggers like this: