I cannot use Directquery over AS then set the composite model

[xuexi5241]

Dear Sirs, 

I’ve tried to import db from my workspace and insert an excel file from local to deploy a composite peocessing,but I cannot import external excel file after loading (the option of AS has been checked)option checked. And it shows the error message as follows:

Feedback Type:
Frown (Error)

Timestamp:
2022-05-27T23:08:27.2890083Z

Local Time:
2022-05-28T07:08:27.2890083+08:00

Session ID:
dc8fec8c-4e4f-46dd-8796-c047092d6452

Release:
May 2022

Product Version:
2.105.923.0 (22.05) (x64)

Error Message:
OLE DB or ODBC error: Errors in the OLE DB provider. The specified Power BI workspace is not found.

Technical Details:
RootActivityId: 04598307-ada0-4263-878d-8aca17cfa2fd.

OS Version:
Microsoft Windows NT 10.0.19044.0 (x64 en-US)

CLR Version:
4.8 or later [Release Number = 528372]

Peak Virtual Memory:
102 GB

Private Memory:
499 MB

Peak Working Set:
708 MB

IE Version:
11.789.19041.0

User ID:
0699ca7d-a81d-4751-8eac-70b35f873e27

Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: False.

Telemetry Enabled:
True

Snapshot Trace Logs:
C:\Users\USER\Microsoft\Power BI Desktop Store App\FrownSnapShotb91833cf-eae2-4165-a38e-f627d375222b.zip

Model Default Mode:
Composite

Model Version:
PowerBI_V3

Performance Trace Logs:
C:\Users\USER\Microsoft\Power BI Desktop Store App\PerformanceTraces.zip

Enabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_compositeModelsOverAS
PBI_useModernFormatPane
PBI_sparklines
PBI_scorecardVisual
PBI_fieldParametersSuperSwitch

Disabled Preview Features:
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_azureMapVisual
PBI_enhancedTooltips
PBI_enableWebView2
PQ_WebView2Connector
PBI_mobileAuthoringFormattingUI
PBI_lineChartError

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
125%

Supported Services:
Power BI

Formulas:

section Section1;

shared #"DirectQuery to AS - Contoso" = let
Source = AnalysisServices.Database("powerbi://api.powerbi.com/v1.0/myorg/Demo%20SQLBI", "Contoso"),
Cubes = Table.Combine(Source[Data]),
Cube = Cubes{0}[Data]
in
Cube;

shared Budget = let
Source = Excel.Workbook(File.Contents("C:\Demos\Budget.xlsx"), null, true),
Budget_Sheet = Source{[Item="Budget",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(Budget_Sheet, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Year", Int64.Type}, {"Brand", type text}, {"Amount", type number}})
in
#"Changed Type";

what should I do now? is there corresponding to my PBI pro version?(I have no premium version yet)from my screen: cannot add excel file from local

[v-yalanwu-msft · Accepted solution]

Hi, @xuexi5241 ;

 the users need to a build permissions of the workspace or if the datasets are in separate workspaces then the users need to be also members of those 2 workspaces.

Now, External users to consume your report means 2 solutions, Either you give them or add them as guests to your workspace with at least a Pro license or the workspace itself needs to move from shared capacity to premium capacity.

Here is a link to Limitations

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-s...

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.