Forum Discussion
Direct Query not working in the October version of Power BI Server
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...
- Authenticate as the user viewing the report, which requires Kerberos authentication to be setup properly - see the following https://docs.microsoft.com/en-us/power-bi/report-server/configure-kerberos-powerbi-reports
- Manually key in credentials of an account that has permissions on your data source - this can either be a windows account (select Windows Authentication from the drop down) or a SQL server account (select Basic Authentication from the drop down)
Hope this helps.
Thanks for the information.
I entered my credentials and it is working now. :smileyhappy:
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