Forum Discussion

WalkerGBG's avatar
WalkerGBG
Frequent Visitor
7 years ago

Sharepoint Multiple File Upload - File layout changes

I currently use PowerBI as a talented amateur and take almost everything I do from the helpfiles and community posts so in no way an expert   Current Situation I've created using the PowerBI deskt...
Need Help
v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi WalkerGBG ,

I have a little confused about your scenario.

Do you have the refresh issue in Power BI Desktop?

In addition, what about changing your query like below?

= Table.TransformColumnTypes(#"Expanded Table Column1",{{"Source.Name", type text}, {"Date", type datetime}, {"OrgID", Int64.Type}, {"Parent", Int64.Type}, {"ProductID", Int64.Type}, {"CustomerName", type text},{"NewFIELD", Int64.Type},COMMENT - etcetcetc, {"", type any}})

If it is convenient, could you share your M query in the Advanced Editor?

Best Regards,

Cherry