Forum Discussion
Querying Database Schema
Hello there! I'm trying to build a data model in Power BI relationship view using a subset of tables from the original Sql server. I'm finding it difficult to connect 2 tables ( patient_info and ...
My client's database is from a 3rd party, that is refusing to provide their database schema or even the primary/foreign keys for a subset of tables. I want to connect Lab results table to the patient table but there isn't any foreign key in the fact table (Lab table) pointing to the patient table..In this situation, i'm thinking there must be some intermediary or bridge table somewhere..but the database is HUGE. I'm going to have to explore every relevant looking table that has lab or patient on it..thats why was thinking of an easier way.
Have you come across a situation when client isn't able to provide a database schema ? (All I got was a document with ~ 35000 fields) what do you do in these situations ??