Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Simple report fails in Service

My entire code (from Advanced Editor):

 

let
Source = Sql.Databases("extd.database.windows.net"),
ExtD = Source{[Name="ExtD"]}[Data],
succe_JobLog = ExtD{[Schema="succe",Item="JobLog"]}[Data],
#"Removed Columns" = Table.RemoveColumns(succe_JobLog,{"file_time", "loaded_timestamp", "size", "status", "object_type", "deletes", "changes", "inserts", "file_name"})
in
#"Removed Columns"

 

 

 

The report looks fine:

 

 

But in the service I get errors like:

 

 

 

 

Why it says analysis services??

 

It also fails with:

 

 

 

Need Help

2 Replies

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    1 year ago

    Hi Anonymous 

     

    Can you confirm in the data source settings if you have set the credentials that will allow it to query back to the data source?

  • SudhavaniKolla3's avatar
    SudhavaniKolla3
    Icon for Helper II rankHelper II
    1 year ago

    can you  open your dataset settings and click on gateways and cloud connections and give credentials one more time and try, it may work.

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.