Forum Discussion
Dataflow fails to return all SharePoint columns
Thanks v-yuta-msft . I think the credentials was a bit of a red herring bought about through some AD mischief that was happening at the time.
The Dataflows are refreshing but erroring in Power BI online:
Something went wrong
There was a problem opening the dataflow editor.
Please try again later or contact support. If you contact support, please provide these details.
Activity ID: 91d8f8f2-bb85-4926-9113-c697933d0809
Request ID: 5cbb37f2-8dc9-92d3-7402-23ddcb4c0a52
Correlation ID: 7e960324-aa78-55f3-5485-8ce28f14eab3
Time: Tue Feb 05 2019 10:40:03 GMT+0000 (GMT Standard Time)
Version: 13.0.8234.157
Cluster URI: https://wabi-north-europe-redirect.analysis.windows.net
When I open the Dataflow in Power BI desktop all columns are present. This narrows the issue down to the Dataflow Preview and Power Query tool that, as mentioned in my initial post, fails to report the correct number of columns. As it fails to report all columns it is not possible to create a query that references a column outside of the 28 unless the query is created in Power BI Desktop and copied across. Even then you do not know if the query will be effective until you save, refresh and add the Dataflow into Power BI Desktop (as you cannot see the results in the Preview).
Anonymous,
Detaflow engoineering team looks into the two issues you reported (problem with preview and refresh failure), and we wll get back to you once we will understand and fix the root cause.
Regards,
Galia
Is there any update on this issue?
Am still facing this issue with the dataflow when connected to SharePOint Online List.
It doesn't return the attachments relative url and othere default fields which used to come in power bi desktop when connected directly.