Hi, I'm trying to get data from PowerBI. I connect...
# troubleshootb
bored-mouse-25356
03/21/2023, 12:47 PMHi, I'm trying to get data from PowerBI. I connected succesfully but ingestion fails. I see following warnings:
Copy code
Non relational data-source found = {'datasourceType': 'Extension', 'connectionDetails': {'path': '...', 'kind': 'Snowflake'}, 'datasourceId': '...', 'gatewayId': '...'} Copy code
[2023-03-21 12:37:24,095] INFO {datahub.ingestion.reporting.file_reporter:52} - Wrote UNKNOWN report successfully to <_io.TextIOWrapper name='/tmp/datahub/ingest/3865c265-8540-4f4c-be96-f59e1d2056af/ingestion_report.json' mode='w' encoding='UTF-8'> Copy code
[2023-03-21 12:37:24,385] ERROR {datahub.entrypoints:213} - Command failed: Failed to fetch reports from power-bi forg
gentle-hamburger-31302
03/21/2023, 12:50 PMCould you please share
• datahub version
• Ingestion log file
• And recipe
b
bored-mouse-25356
03/21/2023, 1:10 PM Copy code
v0.9.5
source:
type: powerbi
config:
tenant_id: id
workspace_id: id
env: PROD
client_id: id
client_secret: id
extract_ownership: false
dataset_type_mapping:
PostgreSql: postgres
Oracle: oraclebored-mouse-25356
03/23/2023, 9:56 AM@gray-shoe-75895 could you look at this one?
a
aloof-gpu-11378
03/23/2023, 4:07 PMIt looks like you’re using cli v0.9.5. Could you try upgrading to latest?
b
bored-mouse-25356
05/08/2023, 2:11 PMHi, we have upgraded to v0.10.2 but still data from one of the workspaces is not fetched (the only difference is that ingestion finishes sucesfully and workspace is fetched). We have multiple datasets there, including ones with Direct Query and only workspace name is fetched. In case of other workspace containing one dataset (import mode) everything is fetched. Logfile for the workspace with DQ and composite models.
g
gentle-hamburger-31302
05/09/2023, 12:47 PMHi @bored-mouse-25356
I can see 401 error in log
gentle-hamburger-31302
05/09/2023, 12:48 PMCould you please follow setup steps mentioned on https://datahubproject.io/docs/quick-ingestion-guides/powerbi/setup
gentle-hamburger-31302
05/09/2023, 12:48 PMwhile replying please tag me
b
bored-mouse-25356
05/10/2023, 8:05 AM@gentle-hamburger-31302 setup on tenant level is OK because I'm able to get full metadata from the other workspace, the only difference is Direct Query in this faulty one.
g
gentle-hamburger-31302
05/10/2023, 8:10 AM@bored-mouse-25356 Could you please share the debug level logs?
gentle-hamburger-31302
05/15/2023, 9:35 AM@bored-mouse-25356 Did you got a chance to generate debug level logs for the issue ?
b
bored-mouse-25356
05/15/2023, 10:13 AMHi @gentle-hamburger-31302 here's the debug log
g
gentle-hamburger-31302
05/15/2023, 10:27 AMThanks
b
bored-mouse-25356
05/29/2023, 10:32 AMHi @gentle-hamburger-31302, how it's going with this one?
g
gentle-hamburger-31302
05/29/2023, 10:35 AMHi @bored-mouse-25356
We are preparing powerbi environment to reproduce this issue at our end.
I will update you once setup is ready
gentle-hamburger-31302
06/06/2023, 5:42 PMHi @bored-mouse-25356
Does Direct Query dataset source belongs to any of SQL, Oracle, Teradata, and SAP HANA ?
gentle-hamburger-31302
06/06/2023, 5:42 PMtag me while replying
b
bored-mouse-25356
06/07/2023, 6:54 AM@gentle-hamburger-31302 it's Snowflake
a
aloof-gpu-11378
06/07/2023, 10:50 AM@bored-mouse-25356
I setup the direct query with snowflake and powerbi connector is ingesting data, I haven't face above issue
aloof-gpu-11378
06/07/2023, 10:50 AMCould you please confirm the security group is added as
adminb
bored-mouse-25356
06/12/2023, 11:20 AM@gentle-hamburger-31302 I confirm
3 Views