Forum Discussion
I cannot use Directquery over AS then set the composite model
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
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
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.
1 Reply
- v-yalanwu-msftCommunity Support
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
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.