Nondescript error in Power BI service for dataflow refresh

[AnthonyMCUBI]

Hi everyone,

I'm having trouble debugging my powerbi dataflows, and would appreciate some guidance. When I try to refresh them I'm given a nondescript error that lists a Request ID, an Activity ID, then nothing else.

Refresh Error 

To resolve this I decided to go to the edit page of the dataflow to see a more descriptive error, but the only information I get is a yellow triangle warning sign at the bottom left. When I hover over it, it says "The query X contains errors."

Power BI Edit Mode Error 

I'm not sure how to get more information. I tried removing the majority of my M code in the advanced editor, but the error remains. I have an on-premise gateway that is ostensibly working. Not sure what to check from here.

Any help understanding what's going on or what to check next would be appreciated.

[v-lionel-msft]

Hi @AnthonyMCUBI ,

Click on the warning message and you will see more tips.

   

If the problem is still not solved, please post your M code(You can copy the code in "Advanced editor".)

Best regards,
Lionel Chen

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

[AnthonyMCUBI]

Thanks for the response.

Below is the popup text box that appears after I clicked the error description mentioned in your response. 

Since the popup doesn't give me extra information, I've also added the M code (in a picture, and then pasted):

let

  Source = Sql.Database("localhost", "Test"),

  dbo_Locations = Source{[Schema = "bi", Item = "LocationCLRDim"]}[Data],

  #"Converted to Table" = Table.SplitColumn(dbo_Locations, "RowData", Splitter.SplitTextByDelimiter("#(tab)", QuoteStyle.None), {"ActiveBusinessDays", "AllowTransfers", "BranchCode", "Description", "LocationCode", "LocationId", "PrinterCode"}),

  #"Renamed Columns" = Table.RenameColumns(#"Converted to Table", {{"ActiveBusinessDays", "Active Business Days"}, {"AllowTransfers", "Allows Transfers"}, {"BranchCode", "Branch Code"}, {"Description", "Location Description"}, {"LocationCode", "Location Code"}, {"LocationId", "Location ID"}, {"PrinterCode", "Printer Code"}}),

  #"Fixed Types" = Table.TransformColumnTypes(#"Renamed Columns", {{"Active Business Days", type text}, {"Allows Transfers", type logical}, {"Branch Code", type text}, {"Location Description", type text}, {"Location Code", type text}, {"Location ID", type text}, {"Printer Code", type text}})

in

  #"Fixed Types"

[v-lionel-msft]

@AnthonyMCUBI ,

This is very strange, I checked your code carefully and found no errors.

What is your data source? SQL Server?

Best regards,
Lionel Chen

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

[AnthonyMCUBI · Accepted solution]

Sorry for the late reply, I figured out the issue.

Power BI recently, apparently had an update to how it connects to SQL CLR databases.  0-length passwords used to be allowed but now are not. I had to change my password from nothing to something in SSMS and then update my password in power bi connection settings. Everything worked fine after that.

I should note that there was no error with my nothing-password until I erased it and put nothing as my password again, which was not allowed and I was asked to input a password. That's why it took awhile to track down.