User Profile
pbi_2004
Frequent Visitor
Joined 1 year ago
User Widgets
Contributions
Re: Changes to Dataverse table structure not coming through to Power BI
If none of the above solutions work for you, it might be an issue with your environment settings. If the environment is in administration mode, it could restrict your access to make changes to the data schema. In this case, you should contact your IT team to disable administration mode. This solution worked for me.3KViews0likes0CommentsRe: Changes to Dataverse table structure not coming through to Power BI
If none of the above solutions work for you, it might be an issue with your environment settings. If the environment is in administration mode, it could restrict your access to make changes to the data schema. In this case, you should contact your IT team to disable administration mode. This solution worked for me.3KViews0likes0CommentsRe: PowerBi connection failed to Yahoo finance
Go Advance editor for that query If not working you can try this, also work - edit with your pair %5EDJI let url = "https://au.finance.yahoo.com/quote/AUDEUR%3DX/history/", headers = [ #"User-Agent" = "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/97.0.4692.71 Safari/537.36", #"Accept" = "text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8", #"Accept-Language" = "en-US,en;q=0.9", #"Cache-Control" = "no-cache", #"Pragma" = "no-cache" ], Source = Web.Contents(url, [Headers=headers]), SourceText = Text.FromBinary(Source), #"Extracted Table" = Html.Table(SourceText, { {"Date", "td:nth-child(1)"}, {"Open", "td:nth-child(2)"}, {"High", "td:nth-child(3)"}, {"Low", "td:nth-child(4)"}, {"Close", "td:nth-child(5)"}, {"Adj Close", "td:nth-child(6)"}, {"Volume", "td:nth-child(7)"} }, [RowSelector="table[class*='yf-ewueuo'] > tbody > tr"]), // Custom function to parse the date and adjust to Australian time ParseAndAdjustDate = (dateText as text) => let parts = Text.Split(dateText, " "), day = Number.FromText(parts{0}), monthMap = #table({"Month", "Num"}, { {"January", 1}, {"Jan", 1}, {"February", 2}, {"Feb", 2}, {"March", 3}, {"Mar", 3}, {"April", 4}, {"Apr", 4}, {"May", 5}, {"June", 6}, {"Jun", 6}, {"July", 7}, {"Jul", 7}, {"August", 8}, {"Aug", 8}, {"September", 9}, {"Sept", 9}, {"Sep", 9}, {"October", 10}, {"Oct", 10}, {"November", 11}, {"Nov", 11}, {"December", 12}, {"Dec", 12} }), month = Table.SelectRows(monthMap, each Text.StartsWith([Month], Text.Proper(parts{1}))){0}[Num], year = Number.FromText(parts{2}), usDate = #date(year, month, day), australiaDate = Date.AddDays(usDate, 1) // Add one day to adjust to Australian time in australiaDate, // Apply the custom date parsing and adjusting function #"Parsed and Adjusted Dates" = Table.TransformColumns(#"Extracted Table", { {"Date", each if _ = null then null else ParseAndAdjustDate(_), type date} }), // Transform other columns to appropriate types #"Changed Type" = Table.TransformColumnTypes(#"Parsed and Adjusted Dates",{ {"Open", type number}, {"High", type number}, {"Low", type number}, {"Close", type number}, {"Adj Close", type number}, {"Volume", Int64.Type} }), #"Replaced Errors" = Table.ReplaceErrorValues(#"Changed Type", {{"Volume", null}}) in #"Replaced Errors"8.6KViews0likes0CommentsRe: PowerBi connection failed to Yahoo finance
try this instead let today = Text.BeforeDelimiter( Text.From( Duration.TotalSeconds(DateTime.LocalNow() - #datetime(1970,1,1,0,0,0)) ), "." ), Source = Json.Document( Web.Contents("https://query2.finance.yahoo.com", [ RelativePath="v8/finance/chart/%5EDJI", Query=[ period1="0", // Start from the earliest available date period2=today, interval="1d", events="history", includeAdjustedClose="true" ] ] ) ), Results = Source[chart][result]{0}, Timestamps = Results[timestamp], Quotes = Results[indicators][quote]{0}, AdjClose = Results[indicators][adjclose]{0}[adjclose], ConvertToTable = Table.FromColumns({ Timestamps, Quotes[open], Quotes[high], Quotes[low], Quotes[close], AdjClose, Quotes[volume] }, {"Timestamp", "Open", "High", "Low", "Close", "Adj Close", "Volume"}), ConvertUnixTimestamp = Table.TransformColumns(ConvertToTable, { {"Timestamp", each #datetime(1970,1,1,0,0,0) + #duration(0,0,0,_), type datetime} }), FormatDates = Table.TransformColumnTypes(ConvertUnixTimestamp, {{"Timestamp", type date}}), SortedTable = Table.Sort(FormatDates, {{"Timestamp", Order.Descending}}), FormattedTable = Table.TransformColumnTypes(SortedTable, { {"Open", type number}, {"High", type number}, {"Low", type number}, {"Close", type number}, {"Adj Close", type number}, {"Volume", Int64.Type} }) in FormattedTable8.7KViews0likes0CommentsPower BI Dataverse Connection Not Reflecting Schema Changes
I recently made changes to my Dataverse schema by adding new columns and a new table. However, when I try to edit my Power BI report, it still shows the old structure. Here's what I've observed: 1. The OData connection shows the new columns and table correctly. but I need to use DirectQuery, so switching to OData is not an option. 2/ Power Apps displays the new columns correctly. 3/This issue only occurs in Power BI. Steps I've already tried: 1/Deleting credentials and logging in again 2/Re-published tables in Dataverse 3/Creating a new connection. 4/Clearing cache 5/Testing on a new computer to rule out cache issues. 6/ Waited for over 24 hours just in case there is a delay None of these solutions have resolved the problem. The Power BI report continues to show the old schema despite the changes made in Dataverse. Questions: 1/Are there any known issues with Power BI not refreshing Dataverse schema changes? 2/Are there any specific steps to force Power BI to recognize schema updates in Dataverse? 3/Could there be any settings in Dataverse or Power BI that might be preventing the schema update from being recognized? Any help or suggestions would be greatly appreciated. Thank you!Solved1.1KViews0likes2Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.