How to import Hierarchical Data Format (HDF) files in Power BI?

[arie_energy]

Is there a way to import Hierarchical Data Format (HDF) files in Power BI, e.g. files with a .h5 file extension?

I have a bunch of large datasets that I want to import and visualize in Power BI.

[chuongho]

You can achive that by use load with python script.

import pandas as pd
import warnings
import os
import time
from tables import NaturalNameWarning
warnings.filterwarnings('ignore', category=NaturalNameWarning)
store = pd.HDFStore('data.h5')
df = store.get('df')
store.close()
df.head()

[lbendlin]

would you mind providing a sample .h5 file?