Forum Discussion
Anonymous
3 years agoNot applicable
DM_GWPipeline_Gateway_MashupDataAccessError
Hi, I'm having the following issue: Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameter...
- Anonymous3 years ago
I found the "issue".
The excel file data was coming from a unique sheet having dates as headers for different topics. In this case, the revenue headers were the same as sales headers (month dates for 2022). I think this was hard to process for PBI because it writes the first 12 columns as 31/1/2022 - 28/2/2022 - ... - 31/12/2022 but the next 12 columns as 31/1/2022_<numberX> - 28/2/2022_<numberY> - ... - 31/12/2022_<numberZ>. I need to delete those numbers (logically) but it seems the server do not read nor create those numbers. As you say, creating a dataflow this might be solved.
Thanks!
Marc
anushka08726
4 months agoNew Member
use EnableQueryResultDownload="0" in the M query Connection