I am processing data in hdinsight spark cluser and storing it into .parquet files.
I made external hive table basing on it and it is populated.
I want to visualise the data in power bi desktop.
It connects to spark hdinsight cluster, sees the tables, even sees schema (shows proper column names).
However it says table is empty. I cannot import data in any way (direct query/import).
I tried also to connect directly to azure storage, but it says access is denied.
Tried also 'hdinsight interactive query' - the same but the preview of data was available.
Most meaningful thing according to me in stack trace:
Resolution of the dependency failed, type = "Microsoft.PowerBI.Client.Windows.AnalysisServices.Relationships.IRelationshipManager", name = "(none)". Exception occurred while: Calling constructor Microsoft.PowerBI.Client.Windows.AnalysisServices.Relationships.RelationshipManager(Microsoft.PowerBI.Client.Shared.IPowerBISettings powerBISettings, Microsoft.PowerBI.Client.Windows.Services.IReportManager reportManager).
Can anyoone help me with this ? I run out of ideas.