User Profile
zrichardson
Advocate III
Joined 9 years ago
User Widgets
Contributions
SSAS live connection and image urls
I am connecting the desktop file to an SSAS tabular model live connection. When you connect live, you don't have the ability to model a measure or column, and that means I cannot display an image that I am trying to. Does anybody know how I would be able to show the image, not just the url?2.2KViews0likes1CommentRe: OneDrive Excel to OneDrive pbix to Power BI Service
That was my thoughts exactly. If you didn't need calculated columns or measures, you could connect the Power BI Service straight to your excel sheet and have hourly updates, but as soon as you want to make any more complex report or use custom visuals, that plan goes out the window.7.8KViews0likes0CommentsRe: OneDrive Excel to OneDrive pbix to Power BI Service
Yes, from what I have gathered, to get an hourly refresh of your OneDrive Excel data, you would have to be directly connected to it through the service. If you connect to the Power BI Desktop report, it will not be updated through the Power BI Hourly Update. If you make any changes to the Desktop Report, those will be picked up on the Hourly Update.7.8KViews0likes2CommentsFirst Date in Group
I have a table with branches and File Start Dates. We don't currently have a branch started date in our database so I was going to use the earliest file start date as the branch start date. This would give us a table like so: BranchID FileStartedDate 1 1/1/2017 1 1/3/2017 1 12/14/2016 2 11/30/2016 2 1/31/2017 3 3/1/2017 3 1/1/2017 3 10/1/2016 I want to add a Calculated Column: BranchStartDate = Calculate(Min(Table[FileStartedDate]), Filter(Table, Table[BranchID]=Earlier([BranchID]))) This gives me a circular reference error. Is there any formula I can use in a calculated column that would give me this result? BranchID FileStartedDate BranchStartDate 1 1/1/2017 12/14/2016 1 1/3/2017 12/14/2016 1 12/14/2016 12/14/2016 2 11/30/2016 11/30/2016 2 1/31/2017 11/30/2016 3 3/1/2017 10/1/2016 3 1/1/2017 10/1/2016 3 10/1/2016 10/1/2016 I should probably say that my File Started Date and Branch ID are on 2 different tables with a 1-1 relationship and cross-directional filtering. Thank you!Solved19KViews1like7CommentsRe: OneDrive Excel to OneDrive pbix to Power BI Service
From what I am gathering, I can't have both. If I want updated data every hour, I have to connect to excel through the service. If I want measures and columns, I need to connect to the power bi report through the service. Is there any way I can have both? Thanks!7.8KViews0likes5Comments
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.