Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
When I try to use Direct Query mode and run a SQL query from the data base to create a report, I am getting the below error, My question is ' Is it mandatory for me to connect to the Analysis Services to connect to the database tables if I want to use Direct Query mode ?' If I use the import mode, the reprot runs fine.
Please help.
Solved! Go to Solution.
This looks like you haven't setup the data sources properly. If you click the ellipsis on the report tile in Report Server, and select Manage, then go to data sources. Scroll down the credentials section, you then have 2 options...
Hope this helps.
Thanks for the information.
I entered my credentials and it is working now.
While connecting to AS cube via direct query i face issue in dataflow... when i try to do the same with Database , i dont get any kind of error... can anyone help... following is the query...
let
Source = AnalysisServices.Databases("abc.de.xyz.net\xyz_CPG", [TypedMeasureColumns=true, Implementation="2.0"]),
CO_LEAN = Source{[Name="CO_LEAN"]}[Data],
#"COLOR LEAN CPG1" = CO_LEAN{[Id="COLOR LEAN CPG"]}[Data],
#"COLOR LEAN CPG2" = #"COLOR LEAN CPG1"{[Id="COLOR LEAN CPG"]}[Data],
#"Added Items" = Cube.Transform(#"COLOR LEAN CPG2",
{
{Cube.AddAndExpandDimensionColumn, "[Article]", {"[Article].[Pack Size].[Pack Size]", "[Article].[Article Material].[Article Material]", "[Article].[Article Material Number].[Article Material Number]", "[Article].[Main Article Material].[Main Article Material]", "[Article].[Main Article Material Number].[Main Article Material Number]", "[Article].[Material].[Material]", "[Article].[Material Number].[Material Number]", "[Article].[Reporting Hierarchy].[Overall Market]", "[Article].[Reporting Hierarchy].[Brand]", "[Article].[Reporting Hierarchy].[Sub Brand]", "[Article].[Reporting Hierarchy].[Market]", "[Article].[Reporting Hierarchy].[Market Segment]", "[Article].[Reporting Hierarchy].[Product]"}, {"Article.SMU Article\Attributes\Keys", "Article.Article Material", "Article.Article Material Number", "Article.Main Article Material", "Article.Main Article Material Number", "Article.Material", "Article.Material Number", "Article.Overall Market", "Article.Brand", "Article.Sub Brand", "Article.Market", "Article.Market Segment", "Article.Product"}}
})
in
#"Added Items"
error message is "Please specify how to connect"
Doesnt work and doesnt populate the gateway server as well
This looks like you haven't setup the data sources properly. If you click the ellipsis on the report tile in Report Server, and select Manage, then go to data sources. Scroll down the credentials section, you then have 2 options...
Hope this helps.
Thanks for the information.
I entered my credentials and it is working now.
Well I have the exact same problem when using DirectQuery and my datasource is SQL Server. Typing in credentials does not solve it! It works fine with SSAS as a datasource when i type in my credentials..
Looks like a bug because every error message I get referes to Analysis Services!
Anyone got a clue?
TIA
Bobby
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
7 | |
3 | |
3 | |
2 |
User | Count |
---|---|
15 | |
11 | |
5 | |
5 | |
2 |