Hi guys! Is it possible to create an upstream lin...
# integrate-powerbi-datahub
f
Hi guys! Is it possible to create an upstream lineage to Power BI Dataset Table from the external source? For instance, I have a Hive table that serves as a source for Power BI Dataset table; if Hive table was created in Datahub, should I see a lineage from it to PBI Dataset table when I ingest data from PowerBI? Or the only possible way to add this type of lineage is to do it manually? Many thanks!
a
you have to manually register the lineage as Hive is not on the supported upstream source DH can pull from M_Query:
Copy code
PowerBI Source supports M-Query expression for below listed PowerBI Data Sources
Snowflake
Oracle
PostgreSQL
Microsoft SQL Server
Google BigQuery
Native SQL query parsing is supported for Snowflake and Amazon Redshift data-sources.
https://datahubspace.slack.com/archives/C034DC21HJN/p1698361899135669
f
Thank you!