ContributionsMost RecentMost LikesSolutionsRe: New Dashboard and Embedding Power BI (sign in issue) Ability to sign into Power BI from a new dashboard is now working. ------------------------------ Brad Elmore ------------------------------ Re: New Dashboard and Embedding Power BI (sign in issue) Ben, Hope all is well with you. I wanted to ask if you have had any responce on this question....or an alternative approach -- but still using the new dashboard. Thank you ------------------------------ Brad Elmore ------------------------------ Re: Help with Formula Query Field with multiple Dates Got it working! needed to switch the OAF & OBF ------------------------------ Brad Elmore ------------------------------ Help with Formula Query Field with multiple Dates I'm trying to get the formula below to work --- ToText(GetFieldValues(GetRecords("{24.EX.'"&[PriceKeyA]&"'}AND{9.OAF.'"&[Invoice Date]&"'}AND{10.OBF.'"&[Invoice Date]&"'}", [_DBID_PRICE_TABLE]), 3)) (Table A) (Table B) *[PriceKeyA] *[Start Date] - fid = 9 *[Invoice Date] *[End Date] - fid = 10 *[PriceKeyB] - fid = 24 *[Record ID] - fid = 3 I want to populate my [formula text field] in (Table A) --- with the [Record ID] from (Table B) -- when [PriceKeyB] (fid 24) = [PriceKeyA] AND [Start Date] (fid 9) >=/OAF [Invoice Date] AND [End Date] (fid 10) <=/OBF [Invoice Date] Any advice? Thank you ------------------------------ Brad Elmore ------------------------------ New Dashboard and Embedding Power BI (sign in issue) I have embedded a Power BI report into a New Dashboard via web page widget -- however when I click on the Power BI "Sign In" --- A new window is launched BUT the Sign-In does not happen......(I have no Issues when embedding a power BI report into the Old Dashboard) --- In order to view the an embedded report within the New Dashboard -- I first have to view the Embedded Power BI report from a Qbase Code Page and sign Into Power BI from the Code Page -- and then go back to the New Dashboard -- then I'm able to view the report. Any suggestions on how to Sign into Power BI from the New Dashboard? ------------------------------ Brad Elmore ------------------------------ Re: Creating a sequential numbering order based on Record ID Thank you Mark -- This worked for me as well. ------------------------------ Brad Elmore ------------------------------ Power BI Connection Question I have created a Qbase table report - and in the option section I have selected CSV as the format. When I click on the report it automatically downloads (which is great) --- I would like to know if it would be possible to connect to this report from Power BI (via Power Query)? I'm currently using the Quickbase Power BI connector -- this works fine -- but it takes a long time to load the data. My hope is that -- maybe I can leverage a Quickbase Report that is formatted as a CSV -- and import the report directly into power bi -- just as a csv or excel file is imported -- resulting in the data loading faster. Is this possible? Not sure if there is an API call via URL that would allow this --- Any suggestions are much appreciated. Thank you ------------------------------ Brad Elmore ------------------------------ Platform Performance Issues? Is anyone else experiencing application performance issues? Slow-loading pages? ------------------------------ Brad Elmore ------------------------------ Re: Powerapps vs Smartsheet vs Quickbase As a Citizen Developer, I've tried many different "low-code" platforms including Salesforce, Power Apps, Quickbase, and a few others. With the goal of creating applications that make it easy for the end user to be better at their job. In order for me to do this effectively as a citizen developer, it must be easy to organize the data based on how "my business does business". I found it easy to build an application on the Salesforce platform - but found it impossible to create an app that allows me to organize the data based on how "my business does business". Salesforce applications make me feel like I'm wearing a "straight jacket" when it comes to organinzing/working with the data in a meaningful way. I'm a big Power BI user (Desktop and Online service) so I tried Power Apps. I found it very hard to create an app – there are alot of moving parts (canvas apps, model-driven apps, dataverse, etc) - and all the moving parts may have additional costs - if you want to take advantage of the of the more advance "no code" features….then you may have to have the "premier" level capability – then any end users who need to view the data must also have the "premier" level. I found that it is actually easier to embed a Power BI report within an Quickbase record form vs a Power App record form. Just like my Salesforce app building experience - "don't color outside the lines", use about 15% of the functionality and get about 10% user adoption. (remember I'm cititizen developer - more advance coder could increase the numbers). I started using Quickbase around 2004 - as an alternative to Sharepoint. I'm a big fan of Quickbase - Very easy take to build an app that has gives context to data. "Color outside the lines" - The area I would like to see improved is reporting. Quickbase reporting is good – for an app that is built to solve a "specific business problem" or even a Project Management app – reporting that hovers around the 1,000 foot view. But for the business reporting that focus at the 50,000 foot view – Reporting that may require querying data from multiple Qbase Apps or even external sources – becomes more of a challenge. Power BI has helped and the Quickbase connector within Power BI works great. I'm sure that for a platform that allows its customers to "Color outside the lines" - to build apps that are effective and actually get used – comes at the cost of how much and how fast changes can be made. It would also be great to see more blog posts and videos that focus on "Ideas to help make your app awesome!" Promoting and sharing "some great tricks on customizing the forms but the dashboards and homepage will always be lacking." The Quickbase platform provides a solution to build simple or complex apps that your end users will actually use. ------------------------------ Brad Elmore ------------------------------ Re: Pipeline Step to Refresh recordMark, thank you for the quick reply. I hope all is well with you and yours. ------------------------------ Brad Elmore ------------------------------