CODEWITHSUNDEEP
sqlpowerbiazure-sql-database
Sandiyan
Sandiyan

Reputation: 1

Power BI Direct query mode - handle multiple tables

I have a azure sql db where all tables sit - fact, dimension other lookups. Have a requirement to pull(3 tables) a fact table, a dimension and another lookup table(not part of star schema) via direct query and be part of data model within Power BI. Direct query doesn't allow more than one table to query against(from a single source). Any thoughts/suggestions?

Upvotes: 0

Views: 1726

Answers (2)

Mr Robot
Mr Robot

Reputation: 322

I tried with mysql db, I able to select multiple tables and load once to power bi.

New Source -> Database -> Mysql Database -> Add host and password ----> then you retrieve window with table list --> it views tables, views , procedures etc....

Upvotes: 0

Sandiyan
Sandiyan

Reputation: 1

Sorry.. thanks to Jon's response, it triggered me to look further and I have found that for each table(from same source) I have to go through 'get data' process. Initially, I thought via one 'get data' process I could multi select tables, but, obviously not. All ok here now.

Upvotes: 0

Related Questions