Hi, I Found a BUG while creating the Date Table with Dax Formula. Please find the details below.   After Creating the table, I tried to modify the name of the Column from "YEAR" (Which is in Caps letters) to "Year" (Small Letters) and I am getting an alert as "The column 'Year' in table 'Date' has invalid bindings specified". Please solve this and you can find the DAX formula which was used by me for creating the table.   Date = VAR vCalender = CALENDARAUTO( ) VAR BaseCalenderColumns = GENERATE( vCalender, VAR vBaseDate = [Date] VAR vDay = DAY(vBaseDate) VAR vMonth = MONTH(vBaseDate) VAR vYearDate = YEAR(vBaseDate) VAR vWEEK = WEEKNUM(vBaseDate) VAR vWeekNo = WEEKDAY(vBaseDate,2) VAR VQtr = QUARTER(vBaseDate) Return ROW( "YEAR", vYearDate, "Month", vMonth, "Month_Name", FORMAT(vBaseDate, "mmmm"), "Day", vDay, "Day_Name", FORMAT(vBaseDate, "dddd"), "Day of Week", vWeekNo, "Week_No", vWEEK, "Quarter", FORMAT(vBaseDate, "\QQ"), "Month_Year", FORMAT(vBaseDate, "mmm YY"), "MonthYearNo", vYearDate*100+vMonth ) ) Return BaseCalenderColumns     ... View more

Hello,   I have started working with Power Bi recently and I am puzzled as to why there isn't a selection for the Values table when I perform: Get Data --> More... --> Online Services --> Microsoft 365 Business Central.   I noticed there is a value table for item dimensions and for item journals when I use the search bar. Because of this, when I bring forth all permutations of the item attribute table, I cannot see the value cell entries regardless if I have established a relationship between ItemAttributeMapping and ItemAttribute (or their permutations) or not.   On MS Business Central, there are values that do exist and is present in the system. However Power Bi does not recognise Config Package table #7501 and all 21255 record rows containing item attribute values: Is there something that I need to set up in Business Central that allows this table to appear? Any help would much be appreciated. ... View more

I have a report using calulated measures which display correctly in Power BI Desktop Report Server (May 2021). When I publish the report to our Report Server web portal and refresh the data, some of the sum totals in the calculated measure seem to be subtracting 1 or rounding down. We have a paginated report that uses the same data source published to PowerBI.com but the totals are correct. Any help would be appreciated. ... View more

Deployment Pipelines are not recognising my changes to a Dataflow, have been testing with simple dataflows and just adding in and removing test columns etc. Because the changes are not recognised, the deployment pipeline won't allow me to deploy to the next workspace to get the updated dataflow in there.   Is this a known issue or is there a way around this? ... View more

Rows with errors are not being removed after applying remove errors to columns or an entire table.     let Source = Folder.Files("X:\Projects\DA_BIM_Resources\BIMLIST-forReports"), #"Filtered Rows1" = Table.SelectRows(Source, each ([Extension] = ".bldb")), #"Expanded Attributes1" = Table.ExpandRecordColumn(#"Filtered Rows1", "Attributes", {"Size"}, {"Attributes.Size"}), #"Removed Other Columns" = Table.SelectColumns(#"Expanded Attributes1",{"Name", "Date accessed", "Date modified", "Date created", "Attributes.Size", "Folder Path"}), #"Added Custom Path" = Table.AddColumn(#"Removed Other Columns", "Path", each [Folder Path] & [Name]), #"getXML Table0" = Table.AddColumn(#"Added Custom Path", "XML Data", each getXML_Table0_DatabaseInfo([Path])), #"Expanded XML Data" = Table.ExpandTableColumn(#"getXML Table0", "XML Data", {"ID", "Name", "LastUpdatedDate", "RemoteServerAddress", "CreatedBy", "LastUpdateBy"}, {"database.ID", "database.Name", "database.LastUpdatedDate", "database.RemoteServerAddress", "database.CreatedBy", "database.LastUpdateBy"}), #"getXML Table 2 - contentItems" = Table.AddColumn(#"Expanded XML Data", "Custom", each getXML_Table2_ContentItems([Path])), #"Expand ContentItems" = Table.ExpandTableColumn(#"getXML Table 2 - contentItems", "Custom", {"ID", "Name", "CategoryID", "Path", "AverageRating", "TotalLoadCount"}, {"ContentItem.ID", "ContentItem.Name", "ContentItem.CategoryID", "ContentItem.Path", "ContentItem.AverageRating", "ContentItem.TotalLoadCount"}), #"Removed Columns" = Table.RemoveColumns(#"Expand ContentItems",{"ContentItem.AverageRating", "ContentItem.TotalLoadCount", "database.LastUpdateBy", "ContentItem.ID", "ContentItem.Name", "ContentItem.CategoryID", "database.LastUpdatedDate", "database.RemoteServerAddress", "database.CreatedBy", "Path", "database.ID", "Date created", "Attributes.Size", "Folder Path", "Name", "Date accessed", "Date modified"}), #"Split Column by Delimiter1" = Table.SplitColumn(#"Removed Columns","ContentItem.Path",Splitter.SplitTextByEachDelimiter({"\"}, QuoteStyle.Csv, true),{"ContentItem.Path.1", "ContentItem.Path.2"}), #"Removed Columns1" = Table.RemoveColumns(#"Split Column by Delimiter1",{"ContentItem.Path.2"}), #"Removed Duplicates" = Table.Distinct(#"Removed Columns1"), #"Renamed Columns" = Table.RenameColumns(#"Removed Duplicates",{{"ContentItem.Path.1", "PathsUnique"}}), #"Filtered Rows" = Table.SelectRows(#"Renamed Columns", each Text.StartsWith([PathsUnique], "S:\_Firmwide\BIMListContent\2017") and Text.Contains([PathsUnique], "Area Tags")), #"Sorted Rows" = Table.Sort(#"Filtered Rows",{{"PathsUnique", Order.Ascending}}), #"Added Custom" = Table.AddColumn(#"Sorted Rows", "AllFilesInAllFolders", each Folder.Files([PathsUnique])), #"Expanded AllFilesInAllFolders" = Table.ExpandTableColumn(#"Added Custom", "AllFilesInAllFolders", {"Name", "Extension", "Date accessed", "Date modified", "Date created", "Attributes", "Folder Path"}, {"Name", "Extension", "Date accessed", "Date modified", "Date created", "Attributes", "Folder Path"}), #"Removed Errors" = Table.RemoveRowsWithErrors(#"Expanded AllFilesInAllFolders") in #"Removed Errors" ... View more

I was importing data from Excel to Power BI and I received this error:   DataFormat.Error: The input couldn't be recognized as a valid Excel document. Details: Binary   It was caused by the first row being set to freeze panes.  After I open the spreadsheet and selected un-freeze panes, it imported successfully. ... View more

Hi Friends,   We want to load more years data to our report by using Incremental refresh. Our model files in Import mode. We use oracle Materialized view as source to load our "sales fact" query.  Currently showing last 3 years data. we want to bring last 10 years of data which never changes and do incremental refresh so daily to be appended daily basis.   Materialized view refreshes in DB for every 1 Hr for now. We cannot do that with 10yrs of data. So one time we want to load 10 Yrs data and continue adding daily data to model.    After achieved above, If want to change something in the model (import type PBIX file), which will be of huge size, we need to move to all non-prod environments (Test & stage) . For now we don't use pipe lines. Just importing manually to other environments.   We dont want to distrub the 10 yr loaded model but we keep add queries/columns/measures in the model and often move thoruogh environments. Is there a way to inherit this model which is loaded with 10 Yr data which should be in Production only and inherited can be used for programming purpose.  Or there should be some other easy way with Azure.   Please suggest best way to achieve this.   Thanks, Yoga ... View more

We are using Perspectives with visual personalization in some of our projects.  We just started using OLS with these models as well.  Currently we have one secured table that only 1 user role should be able to see and access.  We have hidden this table for all other roles.  However we include this table in all Perspectives so the users in the 1 role can slicer their data using this table.  The table appears as an option for all users regardless of their role, but only provides data to the users in the 1 role that has access.  I would think that Perspectives should honor the OLS rules and hide the table in the Persective for users who do not have access.   ... View more

I am receiving below error while launching Power BI desktop App. Tried both Store app and .exe insitallation ,both results with same error.Kindly help resolve it Attaching the screenshot of error message below.         ... View more

Hi All,   Can someone help me by sugessting a DAX formula to repeat DEL column Total in Each row     ... View more

Hi. Guys, how hard would it be to remove this nuisance: The button obstructs the Filter Pane and the pane can't easily be collapsed.   Thanks. ... View more

There was an error when processing the data in the dataset. Please try again later or contact support. If you contact support, please provide these details.   Data source errorWe cannot convert the value "[List]" to type List.. The exception was raised by the IDataReader interface. Cluster URIWABI-WEST-US-redirect.analysis.windows.net Activity IDb086f14b-5950-6c03-35ca-1ebed29a9cc9 Request ID5c0721f5-2c01-4a90-e95d-a37b4e797b75 Time2017-06-12 12:18:02Z   Can you please help?   Below is the query that's causing the error. It works fine in PowerBI Desktop. Fails the refresh routine in PowerBI portal.   let Source = Json.Document(Web.Contents("https://jda.com/api/sitecore/Search/GetKnowledgeCenterSearchResults?mode=expanded")), #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error), #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"body", "color", "contentType", "date", "description", "fileSource", "formattedDate", "headline", "industries", "industryDisplay", "language", "photo", "salesTags", "tags", "title", "url", "urlTarget", "videoID", "videoType"}, {"body", "color", "contentType", "date", "description", "fileSource", "formattedDate", "headline", "industries", "industryDisplay", "language", "photo", "salesTags", "tags", "title", "url", "urlTarget", "videoID", "videoType"}), #"Changed Type" = Table.TransformColumnTypes(#"Expanded Column1",{{"date", type datetime}, {"formattedDate", type date}}), #"Expanded industries" = Table.ExpandListColumn(#"Changed Type", "industries"), #"Removed Columns" = Table.RemoveColumns(#"Expanded industries",{"body", "color", "tags"}), #"Added Custom" = Table.AddColumn(#"Removed Columns", "Pitch Perfect - Solutions.Label", each List.Intersect({[salesTags],List.Distinct(Table.ToList(Table.SelectColumns(SalesCentralMaster,"Solution")))})), #"Added Custom1" = Table.AddColumn(#"Added Custom", "Pitch Perfect - Products.Label", each List.Intersect({[salesTags],List.Distinct(Table.ToList(Table.SelectColumns(SalesCentralMaster,"Product")))})), #"Added Custom2" = Table.AddColumn(#"Added Custom1", "Pitch Perfect Industry.Label", each List.Intersect({[salesTags],List.Distinct(Table.ToList(Table.SelectColumns(SalesCentralMaster,"SubIndustry")))})), #"Expanded Solution" = Table.ExpandListColumn(#"Added Custom2", "Pitch Perfect - Solutions.Label"), #"Expanded Product" = Table.ExpandListColumn(#"Expanded Solution", "Pitch Perfect - Products.Label"), #"Expanded Industry" = Table.ExpandListColumn(#"Expanded Product", "Pitch Perfect Industry.Label") in #"Expanded Industry" ... View more

Hello,  i have few slicers (below). In right item no., in left prod.orders. When i select item i.e. 1007, in other slicer i see related prod.orders. Because there are a lot of orders i want to select them just in one click, so i turn on "Select all" and deselect unnecessary blank values. So far so good, but next when i deselect item no., my slicer with prod.orders select all orders instead showing related orders to item no. 1007. Why? 🙂  ... View more

I have created this view in BigQuery:   create view project.dataset.view1 as SELECT o.first ,o.id as theid ,p.id as otherid FROM dataset.view2 as o JOIN dataset.view3 as p on p.whatever = o.id   When i add the data in that view to PowerBi, the column p.id it shows as Json string with all the three columns, while it should be only an integer. This is an example of what i see:   {""v"":{""f"":[{""v"":""name""},{""v"":""11""},{""v"":""9""}]}}   In BigQuery and also in Google Data Studio and KlipFolio, it just looks fine with the integer value I'm expecting. Can somebody shed some light on this? It's driving me nuts. Thanks. ... View more

Hello,   I'm working with PowerBI Desktop and I did a report to execute TFS/VSTS workitem queries. I used the REST API, so I had to call one API to execute the query and retrieve the workitems IDs and, for each batch of IDs (200 at a time), I call another API to retrieve workitems details. You can download a sample here.   I created some functions an a Query that calls the functions like this:   let queryId = GetQueryId(CollectionUrl, QueryTeamProjectName, QueryPath), queryResult = ExecuteWIQ(CollectionUrl, QueryTeamProjectName, queryId), fieldList = GetFields(queryResult), idList = GetWorkitemIds(queryResult), //Control Parameters countOfIds = List.Count(idList), ItensPerRequest = 200, WorkItemsTable = #table(type table [],{}), Result = GetAllWorkitems(CollectionUrl, idList, fieldList, 0, ItensPerRequest, countOfIds, WorkItemsTable) in Result   When this code runs, I get this error:   Formula.Firewall: Query 'MyQuery' (step 'Result') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination   I build the functions exacly to avoid this kind of error, so I did not understand why I was getting it again. I did some debug, and I discovered that if I returned in the in clause a variable that was not in the last line of the let clause, the error disapears, and the code runs ok!!! Yes, very strange... so if I add an atributtion line of code, that don't means nothing, just to be the last line, and returns the line before it, the error desapears:   let queryId = GetQueryId(CollectionUrl, QueryTeamProjectName, QueryPath), queryResult = ExecuteWIQ(CollectionUrl, QueryTeamProjectName, queryId), fieldList = GetFields(queryResult), idList = GetWorkitemIds(queryResult), //Control Parameters countOfIds = List.Count(idList), ItensPerRequest = 200, WorkItemsTable = #table(type table [],{}), Result = GetAllWorkitems(CollectionUrl, idList, fieldList, 0, ItensPerRequest, countOfIds, WorkItemsTable), //Workaround para erro => Formula.Firewall: Query 'MyQuery' (step 'Result') references other queries or steps, // so it may not directly access a data source. Please rebuild this data combination workaround = 1 in Result   This is the version I used in the template you can download above.   Is this a Bug??    Regards,   Igor Macedo ... View more

Hello! When I registered for Power BI with Office 365 account, it showed... We're sorry, but Microsoft Power BI isn't currently available for your account. Please check back later. We're sorry, but Microsoft Power BI isn't currently available for your account. The same goes for using your school email. Help me how to register a Power BI account. ... View more

你好！当我在Offit365帐户注册电源BI时，它显示。。。很抱歉，微软电源BI目前无法为您的帐户提供。请稍后再查。很抱歉，微软电源BI目前无法为您的帐户提供。使用您的学校电子邮件也是如此。帮助我如何注册电源BI帐户。 ... View more

We have a model in Analysis Services Tabular. Some of the tables contain only visible measures, Power BI marks them automatically as Measures Tables and put them on top of the Fields pane. Other (fact) tables have measures and descriptive columns, they appear between de (dimension) tables. this makes it difficult for our end users to find the proper table, some are in the alphabetical list, others apear at the top. Can this behaviour be switched off, so that all tables are sorted alphabetically, regardless if it only contains visible measures or not? ... View more