cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dyabes
Helper I
Helper I

When expanded column is not returning expected value rather delimited values of the entire row.

The data source is BigQuery and the expected value on the Sessions table is an integer. Why is it that it is returning what appears to be a delimited values of the entire row? 

Appreciate any help. 

 

Cheers,

David

 

8-2-2021 12-42-43 PM.png

1 ACCEPTED SOLUTION
v-yingjl
Community Support
Community Support

Hi @dyabes ,

Currently simliar issue has been sumbited internal.

As a temporary workaround, try to make the table name and the column name be different to avoid this issue.

 

Best Regards,
Community Support Team _ Yingjie Li

View solution in original post

6 REPLIES 6
mahoneypat
Super User
Super User

That column may not contain valid JSON anymore (after Power BI tried to "help").  Are you able to send some example data?  I assume you are getting a JSON response.  If you paste your query URL in a browser you can copy/paste the JSON into a text file, store that in OneDrive or GoogleDrive and provide a link here.

 

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


It looks like the real issue is when the table and column have the same names. 

v-yingjl
Community Support
Community Support

Hi @dyabes ,

Currently simliar issue has been sumbited internal.

As a temporary workaround, try to make the table name and the column name be different to avoid this issue.

 

Best Regards,
Community Support Team _ Yingjie Li

View solution in original post

I went ahead and loaded the table the to model even though in the sample table in PowerQuery is showing a JSON array, lo and behold, it resolves itself and is returning the expected value in the column in the model.

 

Is this a bug that should be reported?

mahoneypat
Super User
Super User

Looks like that column contains JSON.  You could try making a custom column with = Json.Document([Sessions]) to confirm and/or drill into that array.

 

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Hi Pat, 

 

Thank you for looking into my problem. 

 

Added a custom column Json.Document([Sessions]) and records contain the following error message

 

DataSource.Error: ODBC: ERROR [42000] [Microsoft][BigQuery] (70) Invalid query: Unrecognized name: source; Did you mean bounces? at [3:5]
Details:
DataSourceKind=GoogleBigQuery
DataSourcePath=GoogleBigQuery
OdbcErrors=[Table]

 

The preview of the table from BigQuery looks like this.

8-3-2021 4-01-06 PM.png

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

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

Top Solution Authors
Top Kudoed Authors