cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Patron
Post Patron

Urgent Need help - Something gent wrong (Not sure where)

Dear all, 

 

I used to published a report to the power BI service. Recently, I downloaded this report and changed the source setting(file path) and republished with the same name. The refresh works well at my desktop verson, however when I publish to the service, it's not working. Below is the error code.

 

Something went wrong
There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"MySQL: Unknown column 't0_1' in 'field list'"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"MySql"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"127.0.0.1:3306;suitecrm"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"Unknown column 't0_1' in 'field list'"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: f_calls.
Cluster URI: WABI-CANADA-CENTRAL-redirect.analysis.windows.net
Activity ID: d368c075-e20e-4c0f-b443-7360f3ca143d
Request ID: 7c68bb61-e02a-3787-afbc-b2c859579d20
Time: 2020-07-04 01:41:58Z

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Urgent Need help - Something gent wrong (Not sure where)

Hi @xiumi_hou ,

So you haved re-configured the data soucre of the gateway and the gateway worked fine right?

If so, please note this error message:

"Unknown column 't0_1' in 'field list'"

Seems like there is an undefined column in your data source, please check your column name of data source in details, delete all the same name reports in power bi service, republish it to power bi service and configure the right path and data source in the gateway to try it again.

 

Best Regards,
Yingjie Li

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

View solution in original post

5 REPLIES 5
Highlighted
Super User IV
Super User IV

Re: Urgent Need help - Something gent wrong (Not sure where)

Does your gateway have access / permission to the new data sources?

jdbuchanan71_0-1593828641739.png

 

Highlighted
Post Patron
Post Patron

Re: Urgent Need help - Something gent wrong (Not sure where)

@jdbuchanan71 Thanks for answering. Yes, the gateway works well and with the permission to those files.  It used to worked pretty well,  not sure why I changed the data source file and it not worked now.... but it worked at my desktop version. Any advice? Thanks

Highlighted
Super User IV
Super User IV

Re: Urgent Need help - Something gent wrong (Not sure where)

Check under the data source credentials, it's the only thing I can think of.

jdbuchanan71_0-1593833672939.png

 

Highlighted
Post Patron
Post Patron

Re: Urgent Need help - Something gent wrong (Not sure where)

@jdbuchanan71 Thanks for this. The admin has granted credentials, I guess something wrong with my tables since it works on my desktop version...

Highlighted
Community Support
Community Support

Re: Urgent Need help - Something gent wrong (Not sure where)

Hi @xiumi_hou ,

So you haved re-configured the data soucre of the gateway and the gateway worked fine right?

If so, please note this error message:

"Unknown column 't0_1' in 'field list'"

Seems like there is an undefined column in your data source, please check your column name of data source in details, delete all the same name reports in power bi service, republish it to power bi service and configure the right path and data source in the gateway to try it again.

 

Best Regards,
Yingjie Li

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

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors