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.
Hello Community!
Since I've installed December 2020 updtade of the On-premise data gateway; a previously working dataset, which was connecting to an Oracle Datasource now throws an error related to the character set. So far I've checked the versions of the software I'm using and:
All other datasets connecting to the same datasource are working as expected. The error on the dataset refresh:
Any clues why I'm getting this error now? The data set works perfectly fine in the Desktop version 🙄.
Thank you everyone for the help!!
Solved! Go to Solution.
After tinkering a lot with this problem. I've figured out how to avoid the problem and it works flawlessly although I don't really understand why.
The merge step generated by the power query editor is like so:
Table.CombineColumns(#"Removed Other Columns",{"IMDSC1", "IMDSC2"},Combiner.CombineTextByDelimiter("", QuoteStyle.None),"Merged")
You get always this error:
The QuoteStyle.None function inside the Combiner.CombineTextByDelimiter makes the whole thing fail. If you remove this piece of code like so:
Table.CombineColumns(#"Removed Other Columns",{"IMDSC1", "IMDSC2"},Combiner.CombineTextByDelimiter(""),"Merged")
Magic happens:
You get your data back as you would expect.
The reason why this is the problem escapes my understanding. On top of that the documentation on these functions is less than ideal. If anyone knows why this happens let me know! I'm now curious 😋
After tinkering a lot with this problem. I've figured out how to avoid the problem and it works flawlessly although I don't really understand why.
The merge step generated by the power query editor is like so:
Table.CombineColumns(#"Removed Other Columns",{"IMDSC1", "IMDSC2"},Combiner.CombineTextByDelimiter("", QuoteStyle.None),"Merged")
You get always this error:
The QuoteStyle.None function inside the Combiner.CombineTextByDelimiter makes the whole thing fail. If you remove this piece of code like so:
Table.CombineColumns(#"Removed Other Columns",{"IMDSC1", "IMDSC2"},Combiner.CombineTextByDelimiter(""),"Merged")
Magic happens:
You get your data back as you would expect.
The reason why this is the problem escapes my understanding. On top of that the documentation on these functions is less than ideal. If anyone knows why this happens let me know! I'm now curious 😋
Still not working!
After near a year of dealing with the error I finally have some time to focus on trying to solve it. But with no success 😥. I'll try to add as much information as I can, and if someone has solved the same kind of error in another DBMS system may work as well.
Setup
Current running software versions at the time of writing:
The Error
Originally, I found the error with the data gateway but, the error can be reproduced in Power BI Desktop as well. The error happens when:
The code for both queries is the same except for the source definition.
let Source = #"PRODDTA ODBC", Table = Source{[ Name = "F4101" ]}[Data], #"Removed Other Columns" = Table.SelectColumns ( Table, { "IMDSC1", "IMDSC2" } ), #"Merged Columns" = Table.CombineColumns ( #"Removed Other Columns", { "IMDSC1", "IMDSC2" }, Combiner.CombineTextByDelimiter ( "", QuoteStyle.None ), "IMDSC" ) in #"Merged Columns" |
Hi, @MiquelDespuig
Could you please tell me whether your problem has been solved?
For now, there is no content of description in the thread.
If you still have this issue for Power BI, you'd better create a support ticket in Power BI Support to get further help.
https://powerbi.microsoft.com/en-us/support/
Best Regards,
Community Support Team _ Eason
Hi, @MiquelDespuig
What mode is used, directquery or import?
This error looks like the result of inconsistent data types in the table during the query, have you changed any data types of the columns in the oracle table or table name?
If the issue occurs only for this specific report , it is suggested to republish the report to another workspace and reconfigure a new Oracle data source in the gateway.
Best Regards,
Community Support Team _ Eason
Hello @v-easonf-msft ,
First sorry for the late answer 😔!
The report is running on Import Mode. I haven't modified the query on the data-source, although I'll make a thorough check for mismatching data-types.
I've also tried to publish the report in my workspace and I got the same error. What a didn't try is to replace the gateway connection with a new one. Oracle connections are kind of tricky and chaning them may bite you, but I'll try anyways.
Thank you!! I'll let you know when finished!
In Power Query try this:
- Right click on your data column
- Scroll down to 'Transform'
- Click on 'Clean'
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.