Forum Discussion
Converting ColumnsUpdated Field
Greg_DecklerI was able to solve this issue by created a CTE in the Advanced Options of Get Data, setting up the relationship, and then displaying the parsed ColumnsUpdated from the CTE in a report.
The SQL I ran during import was:
WITH ChangeLog_CTE (Guid, ParsedUpdatedColumns) AS ( SELECT Guid, (dbo.[GetChangedColumns]('History.Resources', History.Resources.ColumnsUpdated)) AS ParsedUpdatedColumns FROM History.Resources ) SELECT * FROM ChangeLog_CTE;
Community ChampionI'm following about half of this. In Power BI you don't generally update existing columns and tables, it is for reporting.
Greg_DecklerI was able to solve this issue by created a CTE in the Advanced Options of Get Data, setting up the relationship, and then displaying the parsed ColumnsUpdated from the CTE in a report.
The SQL I ran during import was:
WITH ChangeLog_CTE (Guid, ParsedUpdatedColumns)
AS
(
SELECT
Guid,
(dbo.[GetChangedColumns]('History.Resources', History.Resources.ColumnsUpdated)) AS ParsedUpdatedColumns
FROM
History.Resources
)
SELECT *
FROM ChangeLog_CTE;
- Greg_Deckler
Anonymous , glad you got it figured out. Yes, the Advanced Options will let you run whatever SQL Query you desire. Didn't think of that as the answer to your question because I'm still not exactly sure what you are going for!! :)