The current version of the data source browser in PBI desktop only seems to support a limited numer of objects. Only the first 10.000 objects are shown in the list - and it becomes sloooow. If the de...
kclubok
6 years agoNew Member
I have found that even on a database with over 10,000 objects, you can access the tables beyond the first 10,000. First, use the search to select one of the tables in the first 10,000. PBI will create a query against that table that you can see and manipulate in the Query Editor. From the Query Editor, right-click that query, and then select "Duplicate". Then right-click on the new copy you just made, and select "Advanced Editor". Replace the old table name with any table name you like, and click "Done". Right-click on that query again, and select "Properties" in order to change the name to the name of your table, and you're done! It's a lot less convenient than using the dialog, but at least you're not completely dead in the water.
Recent ideas
Justification Prompts When Downgrading or Removing Sensitivity Labels in Power BI Desktop
Description Currently, organizations can configure Microsoft Purview sensitivity label policies to require users to provide a justification when removing a label or lowering its classification. T...vvargasv12 hours agoMicrosoft EmployeeNew11Views0likes0CommentsVisual Type Defaults in Visualization Pane
This would change my life with fussy clients and client/public facing apps. In addition, it would allow me to add more value to the clients on retainers who do not have the 'hours' to allocate to...IolaWhiteley13 hours agoAdvocate IINew48Views7likes0CommentsMatrix: column totals as a bar chart docked to the edge
What's missing Data bars already work on the Total row and column through conditional formatting, so row totals can be read as length. Column totals cannot: they render as a horizontal bar inside a ...Sayurivalente14 hours agoRegular VisitorNew79Views6likes1CommentAllow Bookmarks to Affect Multiple Report Pages
Description: I would like to request the ability for a single Power BI bookmark to affect and maintain a state across multiple report pages, rather than being limited to a single page. For example,...Josegonzalez2114 hours agoNew MemberNew20Views4likes1CommentFeature Proposal: Expandable/Collapsible Page Sections for Reports on Same Semantic Model
Subject: Feature Proposal: Expandable/Collapsible Page Sections for Reports Using the Same Semantic Model Dear Microsoft Power BI Team, I would like to propose an enhancement to the Power BI report...Dr7awb14 hours agoNew MemberNew32Views1like1Comment