• g

    gentle-hamburger-31302

    6 months ago
    Hi @damp-queen-61493 The PowerBi source is merged into upstream. Looking forward for your feedback.
    g
    l
    2 replies
    Copy to Clipboard
  • d

    damp-queen-61493

    6 months ago
    Hi! I received this error:
    File "/home/hveiga@acesso.digital/Documents/dev/pyCharmProjects/dataengineering-airflow/venv/lib/python3.8/site-packages/datahub/ingestion/source/powerbi.py", line 463, in get_dashboards
        441  def get_dashboards(self, workspace: Workspace) -> List[Dashboard]:
     (...)
        459      # Check if we got response from PowerBi
        460      if response.status_code != 200:
        461          LOGGER.warning("Failed to fetch dashboard list from power-bi for")
        462          LOGGER.warning("{}={}".format(Constant.WorkspaceId, workspace.id))
    --> 463          raise ConnectionError(
        464              "Failed to fetch the dashboard list from the power-bi"
        ..................................................
         self = <datahub.ingestion.source.powerbi.PowerBiAPI object at 0x7fd5a6890910>
         workspace = PowerBiAPI.Workspace(id='882789ab-7714-45ff-a15a-53eeceb6ae97', name='Data Analytics', state='Active', dashboards=[], da
                      tasets={})
         List = typing.List
         response.status_code = 401
         LOGGER.warning = <method 'Logger.warning' of <Logger datahub.ingestion.source.powerbi (INFO)> __init__.py:1448>
         Constant.WorkspaceId = 'WorkspaceId'
         workspace.id = '882789ab-7714-45ff-a15a-53eeceb6ae97'
        ..................................................
    
    ---- (full traceback above) ----
    File "/home/hveiga@acesso.digital/Documents/dev/pyCharmProjects/dataengineering-airflow/venv/lib/python3.8/site-packages/datahub/entrypoints.py", line 124, in main
        sys.exit(datahub(standalone_mode=False, **kwargs))
    File "/home/hveiga@acesso.digital/Documents/dev/pyCharmProjects/dataengineering-airflow/venv/lib/python3.8/site-packages/click/core.py", line 829, in __call__
        return self.main(*args, **kwargs)
    File "/home/hveiga@acesso.digital/Documents/dev/pyCharmProjects/dataengineering-airflow/venv/lib/python3.8/site-packages/click/core.py", line 782, in main
        rv = self.invoke(ctx)
    File "/home/hveiga@acesso.digital/Documents/dev/pyCharmProjects/dataengineering-airflow/venv/lib/python3.8/site-packages/click/core.py", line 1259, in invoke
        return _process_result(sub_ctx.command.invoke(sub_ctx))
    File "/home/hveiga@acesso.digital/Documents/dev/pyCharmProjects/dataengineering-airflow/venv/lib/python3.8/site-packages/click/core.py", line 1259, in invoke
        return _process_result(sub_ctx.command.invoke(sub_ctx))
    File "/home/hveiga@acesso.digital/Documents/dev/pyCharmProjects/dataengineering-airflow/venv/lib/python3.8/site-packages/click/core.py", line 1066, in invoke
        return ctx.invoke(self.callback, **ctx.params)
    File "/home/hveiga@acesso.digital/Documents/dev/pyCharmProjects/dataengineering-airflow/venv/lib/python3.8/site-packages/click/core.py", line 610, in invoke
        return callback(*args, **kwargs)
    File "/home/hveiga@acesso.digital/Documents/dev/pyCharmProjects/dataengineering-airflow/venv/lib/python3.8/site-packages/datahub/telemetry/telemetry.py", line 181, in wrapper
        raise e
    File "/home/hveiga@acesso.digital/Documents/dev/pyCharmProjects/dataengineering-airflow/venv/lib/python3.8/site-packages/datahub/telemetry/telemetry.py", line 173, in wrapper
        res = func(*args, **kwargs)
    File "/home/hveiga@acesso.digital/Documents/dev/pyCharmProjects/dataengineering-airflow/venv/lib/python3.8/site-packages/datahub/cli/ingest_cli.py", line 87, in run
        pipeline.run()
    File "/home/hveiga@acesso.digital/Documents/dev/pyCharmProjects/dataengineering-airflow/venv/lib/python3.8/site-packages/datahub/ingestion/run/pipeline.py", line 183, in run
        for wu in itertools.islice(
    File "/home/hveiga@acesso.digital/Documents/dev/pyCharmProjects/dataengineering-airflow/venv/lib/python3.8/site-packages/datahub/ingestion/source/powerbi.py", line 1352, in get_workunits
        workspace = self.powerbi_client.get_workspace(self.source_config.workspace_id)
    File "/home/hveiga@acesso.digital/Documents/dev/pyCharmProjects/dataengineering-airflow/venv/lib/python3.8/site-packages/datahub/ingestion/source/powerbi.py", line 889, in get_workspace
        workspace.dashboards = self.get_dashboards(workspace)
    File "/home/hveiga@acesso.digital/Documents/dev/pyCharmProjects/dataengineering-airflow/venv/lib/python3.8/site-packages/datahub/ingestion/source/powerbi.py", line 463, in get_dashboards
        raise ConnectionError(
    
    ConnectionError: Failed to fetch the dashboard list from the power-bi
    d
    1 replies
    Copy to Clipboard
  • d

    damp-queen-61493

    6 months ago
    In our case, a service principal account doesn't has privileges inside workspace to query dashboard. We want to use only admin API to scan and retrieve pbi assets
    d
    l
    +1
    12 replies
    Copy to Clipboard
  • w

    wooden-arm-26381

    5 months ago
    Hi, while testing the connector, I noticed that after the metadata ingestion finished, the report showed that zero
    workunits
    have been produced. The workspace consists mainly of reports. The Service Principal I’m using has read access via the Admin API. The log shows some activity too. I’m not sure for the reason of this problem. Anyone else experienced something similar?
    w
    l
    +1
    3 replies
    Copy to Clipboard
  • j

    jolly-greece-23824

    3 months ago
    Hey, My timezone is CET (Amsterdam). Let me now when you have time, thanks! Regards, Sadesh
  • g

    gentle-hamburger-31302

    2 months ago
    Hi @jolly-greece-23824 Can we take a call tomorrow at 10 AM your time ?
  • d

    damp-queen-61493

    1 month ago
    Hi all, Is there any roadmap to map PowerBI reports to Datahub entities?
    d
    1 replies
    Copy to Clipboard
  • m

    modern-artist-55754

    3 weeks ago
    question, does anyone has success with Lineage? We use snowflake as the datasource but i cannot see any lineage, we only have lineage between chart & report