Extracting SQL Database/Table Names From Your Power BI Dataset!

preview_player
Показать описание
Learn how to query the XMLA end-point in a Premium (Per User or Capacity) workspace to extract all the Power Query M Code, and parse out your SQL Database names, table, names, and parameters from your queries. Tune in to learn more.

RELATED CONTENT 🔗

BECOME A CHANNEL MEMBER 🎉

CHECK OUT OUR MERCH STORE 👕

LET'S CONNECT! 🧑🏽‍🤝‍🧑🏽 🌟

HAVENS CONSULTING PAGES 📄

EMAIL US AT 📧

#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax
  1. Havens Consulting
  2. Power BI
  3. PowerBI
  4. PBI
  5. DAX
  6. Data Modeling
Рекомендации по теме
Extracting SQL Database/Table 0:08:56

Extracting SQL Database/Table Names From Your Power BI Dataset!

How to get 0:00:38

How to get COLUMN NAMES in SQL

Get all table 0:05:09

Get all table names and column names of database in SQL Server database

Get Table Names 0:05:47

Get Table Names with Column Names and Data Types in SQL Server - SQL Server Tutorial

Extract Table & 0:04:38

Extract Table & Column names from Query using Python SQL Metadata library in Databricks Notebook

How to Search 0:04:04

How to Search Table by Name in SQL Server

How to get 0:03:19

How to get list of all tables in database SQL Server

Display List schemas 0:01:52

Display List schemas in SQL Server database

How to build 1:44:10

How to build Secure Conversational Analytics / Text to SQL.

Retrieving a list 0:05:49

Retrieving a list of SQL Server objects (constraints, tables, views, functions) using sys.objects

Get all usernames 0:07:09

Get all usernames and password | sql injection union attack retrieving data from other tables

Find all Tables 0:07:55

Find all Tables that contain a specific Column name in SQL Server Database

SQL Tips | 0:00:23

SQL Tips | How to Find All Tables containing a Column? #sqltips

How to extract 0:04:25

How to extract domain name from an email address in sql server?

How to export 0:05:49

How to export data from SQL server to Excel | Export table records to Excel | SQL DBA

How to split 0:09:23

How to split full_name into first_name and last_name in sql and information expr transformation.

Oracle SQL Practical 0:07:36

Oracle SQL Practical question with answer extract names from mail id using SQL function

Get all table 0:07:20

Get all table names of a particular database by SQL query | Part - 8

SELECT query in 0:07:21

SELECT query in SQL - Retrieval of records from a table

SQL query to 0:04:59

SQL query to get the string before or after any specific character (Substring, Charindex)

Using SQL to 0:10:32

Using SQL to Select Records from Multiple Tables

5 Basic SELECT 0:06:43

5 Basic SELECT Statement Queries in SQL

How to get 0:00:19

How to get FIRST CHARACTER of STRING in SQL

How to Copy 0:04:28

How to Copy Data from One Table to Another Table in SQL Server Management Studio

Комментарии
Автор

Thanks for the video ! I tried it but I do not get all the expressions. Any idea of what can be the cause ?

yannickfranckum
Автор

Hello Sir
I'm facing an issue to implement a row number by partition... But as all the columns are identical within the partition due to which it's assigns 1 as row number to each row in each partition. Can you please help in implementing this using the Dax... Thanks

raghavgupta