Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Direct Query Dataflow published as part of dataset does not work

We created a dataflow in the power bi service with Table 1

We added Table1 from this dataflow in the Power BI file as direct query Say File1.Pbix

Published File1.pbix

Added File1 as a dataset in File2.Pbix

 

Table 1 does not show any data and give an error

 

 

Feedback Type:
Frown (Error)
 
Timestamp:
2021-07-28T10:27:29.9059196Z
 
Local Time:
2021-07-28T15:57:29.9059196+05:30
 
Session ID:
7ea1e221-4211-4b20-be1f-740ff5d1122a
 
Release:
May 2021
 
Product Version:
2.93.981.0 (21.05) (x64)
 
Error Message:
{"error":{"code":"DMTS_MonikerWithUnboundDataSources","pbi.error":{"code":"DMTS_MonikerWithUnboundDataSources","details":[{"code":"Server","detail":{"type":1,"value":"10.83.213.92"}},{"code":"ConnectionType","detail":{"type":0,"value":"Teradata"}}],"exceptionCulprit":1}}}
 
OS Version:
Microsoft Windows NT 10.0.18363.0 (x64 en-US)
 
CLR Version:
4.7 or later [Release Number = 528040]
 
Peak Virtual Memory:
38.8 GB
 
Private Memory:
649 MB
 
Peak Working Set:
964 MB
 
IE Version:
11.1411.18362.0
 
User ID:
342ad00a-231f-46d9-a39a-ebb4bad1007c
 
Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.
 
Telemetry Enabled:
True
 
AS Live Connection:
True
 
Performance Trace Logs:
C:\Users\z004bzrm\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip
 
Enabled Preview Features:
PBI_JsonTableInference
PBI_NewWebTableInference
PBI_ImportTextByExample
PBI_ExcelTableInference
PBI_eimInformationProtectionForDesktop
PBI_cartesianMultiplesAuthoring
 
Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_azureMapVisual
PBI_dataPointLassoSelect
PBI_compositeModelsOverAS
PBI_dynamicParameters
PBI_enhancedTooltips
 
Disabled DirectQuery Options:
TreatHanaAsRelationalSource
 
Cloud:
GlobalCloud
 
DPI Scale:
100%
 
Supported Services:
Power BI
 
Formulas:
 

section Section1;

 

Status: New
Comments
v-chuncz-msft
Community Support

@amitchandak 

 

I tried the latest version and it works fine for me. You may check Data source credentials in the dataset settings.