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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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.