Enable Project Online as a source (beyond the rather slow oData feed that exists) to enable large organizations to report directly from PO. Currently using oData with slow performance and rigid paging of data returned that makes large datasets perform suboptimal.
13 Comments
- nishalitNew MemberThanks for the suggestion, Trond! If anyone else thinks that Project Online is an important data source, please add your vote!
- fbcideas_migusrNew MemberEven with OData, it doesn't allow you to refresh (manually or scheduled). To get new data to show up now, I need to open the .pbix file I have stored locally in Power BI Designer, then refresh, and upload the file. Then I need to delete the old one since it doesn't overwrite it and I need to pin any report elements I want back to a dashboard (basically recreating it from scratch).
- SylvainGrossNew MemberThis is a really important feature. The OData feed can be acceptable in certain cases, where you hav to access to general information of the project. But sometimes you have to access to timephased data: in that cas the number of row is very important, and the time is really too long: more than 10 minutes, and often you get a timeout error. With a direct link, the performance would be much better !
- MARCBI2New MemberTotally agree, a connection with Project Online is very important. Project management consists also to manage Cost, KPI, etc...
- aaron_boggsNew Member'+1 on this feature request, and I echo the same sentiments that @SylvainGrossNeo said regarding the time it takes to pull in timephased information via OData.
- fbcideas_migusrNew MemberWould love to see this one added.
- didierma3New MemberGeneral Manager and Program managers need Project OnLine as datasource in Power Bi portal, as a vital tool to supervise the P&L concerning contracts and proojects sold to customers. This is a top priority for my present customers.
- evanhurckNew MemberThis would make my day! As a consultant for Project Online this is a key issue for selling the product. Slow performance on OData.
- Max
Advocate I
We'd love to see this one added, and given that is data in Microsoft's own datacenters it should be easy and fast :) - juan5New Memberif you have a connector to crm online why not have porject online, it's very neccesary for BI in Project online. Excel isnt a good solution for BI Reporting
Recent ideas
Power BI, import report and semantic model: show change connection pop-up
When you need to import an existing Power BI report and semantic model in Tenant B that's created in Tenant A, you need to jump through a number of hoops to fix the original connection. It's doable, ...Reitse1 hour agoMost Valuable ProfessionalNew4Views1like0CommentsEnable per-user security for shared gateway connections using service accounts
When a shared gateway connection uses a highly privileged service account, all source queries run with that account’s permissions. Users cannot see the stored credentials, but report developers who c...AshishChougala1 hour agoMicrosoft EmployeeNew6Views3likes0CommentsRequest to add a feature to extract gateway connection status and last time credentials used
Could you please add a feature in the admin UI on Microsoft Fabric/Power BI to extract the Gateway connections with details of the gateway connection status and last activity information along with t...Vinodkumar_Chak3 hours agoNew MemberNew21Views1like0CommentsPower BI - incorrect handling of empty string parameter in DAX query in paginated report
Blank string parameters in paginated reports are treated as empty strings in Power BI Report Builder but as null values in the Power BI Service, resulting in incorrect report output. -> Create a pag...roshinikumarkar6 hours agoMicrosoft EmployeeNew25Views5likes0CommentsAllow NotebookUtils getSecret() to authenticate with Workspace Identity
Current behavior In Microsoft Fabric, notebookutils.credentials.getSecret() authenticates against Azure Key Vault using the identity of the user who executes the notebook. This behavior appli...tmihara8 hours agoNew MemberNew20Views1like1Comment