Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Getting data from hive to power bi

I have n tables in Hive database, need to retrieve the table name and schema name at a time and store it to .csv file/excel file. And pull this data to power bi for reporting purpose.

For pulling to power bi I tried to install ODBC driver but it will fetch the tables and tables details, but I need to retrieve the only table name and schema name from hive .

 

Need Help
Show and Tell

1 Reply

  • v-lid-msft's avatar
    v-lid-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    Sorry for that, but I also not found an effective solution to storetable name and schema name to .csv file/excel file within Power BI.

     

    Or you make a customize connector to get the data you need if you are an experienced developer.

     

    Best regards,

    Community Support Team _ Dong Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.