I am getting an error when a visual is being loaded that I can't find referenced after a google search.
For my report, I followed the instructions here: https://docs.microsoft.com/en-us/power-query/power-query-query-parameters and everything is working fine in the Desktop App. But when I publish the report, the online app is producing the following error:
"The cartridge generated a statement that is not valid because more than one text statement was generated, the statement was not the correct type, or more than one parameter list was generated. The generated statement that is not valid is: ."
I have a simple table visual pulling maybe 9 columns. The data is coming from a SQL Database table that contains several million rows. I am using a view built to display the data I am presenting in the BI visual, but need to be able to select a particular ID from the table which limits the returned rows to only a couple of hundred. But the user needs to be able to select the ID. So so loading the whole table isn't feasible-- I really wish that BI would allow a parameter/variable to be passed to a TVF or SProc, but alas. The Slicer I'm using to establish the parameter is loading fine, but the table isn't. Has anyone come across this or have any suggestions?
