Forum Discussion
Change Sequenced data to Columns
Hey All. I have a PowerBI model that has a table that contains Ids of applications, platform and the platform sequence. The platform sequence refers to which platform the app will migrate to over tim...
It seems that in your table there is no AppId column. 🙂
I thought the same 😄 initially. This is the table I am basing it off of and it has AppId. I also get the error when changing to ID or Id??
Should I create a blank query for the syntax or create table?
Crate a table from your SQL connection, then give me a code from advanced editor. I will apply rest of the steps for you.
let
Source = Sql.Database("LOUSQLWTS711", "AppJourneyTrackingDB_Dev"),
Roadmap_AppTargetPlatform = Source{[Schema="Roadmap",Item="AppTargetPlatform"]}[Data]in
SourceGive me also a colum names, because this is an issue here.
I need Id, AppId, PlatformName, and PlatformSequence
Did you need any other info?
I still have no resolution for this 😞