The new "Include in Report Refresh" released in July 2016 is a great addition - now the data modeller can selectively turn on/off tables to be refreshed. It would be great to allow the user to set parameters and events to control when a table is refreshed. Eg a parameter that says "if a server cannot be found, then skip the refresh for a certain table". Maybe also allow users to set other events (or error codes) where selective processing can be managed. This will allow granular management of refreshing when a user needs to partially refresh a workbook as described here http://exceleratorbi.com.au/?p=17985
19 Comments
- fbcideas_migusrNew MemberSuper idea to pass the trigger into the hands of the users!
- tom45New MemberError and event handling for this feature will elevate it to a benefit!
- ya_bondarenko_iNew MemberGood idea! Very useful in some cases.
- nick_raphael1New MemberI have a table of 50 million rows that never changes. I have a table of 1 thousand rows that needs hourly refreshing. Unless I can exclude the 50mill table from hourly refreshing, then I'm pretty much boned.
- anurodh_gargNew MemberThe power bi schedule refresh should be customized and allow refresh of specific data tables also. Some tables data is static and do not need any refreshing but the schedule refresh refreshes entire dataset. please solve this to make this functionality better
- evang5502New MemberPlease address this!
- andrey_minakovNew MemberIt's very strange not to have ability to just append data to uploaded before. I think this should be in the product from the very beginning.
- jan_cietersNew Membershould be a gift and lot's of time gain.
- wout_olyslagersNew MemberPlease also make the PowerBI Service respect the option "Include in report refresh". Right now when I add a static data source (eg. zip-codes) which I don't want to refresh through the gateway, I can't use the gateway at all because he can't find the file with the zip-codes.
- amicoda1New MemberMust have feature!
Recent ideas
Blocker: Purview must scan Fabric Warehouse tables/columns or we will deprecate Purview
Purview + Fabric Warehouse ≠enterprise‑ready governance. In our environment, the Fabric Warehouse is the system of record, but Purview can only catalog the warehouse container—not the tables or co...Joshua_Hernande7 hours agoNew MemberNew180Views1like1CommentPower Query Parameter create/use when connecting to a dataflow
In power query when you connect to a table in a dataflow there are no options to create or use a parameter for that dataflow. When connecting to SQL there is an option when setting up the connection ...ben_holmes15 hours agoNew MemberNeed Clarification198Views3likes1CommentParameterize Dataflow Gen2 data source connection
Allow the Dataflow Gen2 data source connection GUID to be parameterized and stored in a Variable Library. This would allow the same Dataflow to use different connections depending on the workspace/e...frithjof_v15 hours agoCommunity ChampionNeeds Votes37Views2likes1CommentExpose Power Query as a Standalone Runtime and Command-Line Interface (CLI)
Summary Power Query has evolved into one of Microsoft's most powerful data transformation technologies and is now used across Excel, Power BI, Fabric, Dataflows, Power Platform, and other products. ...juansgr_15 hours agoNew MemberAbandoned27Views0likes2CommentsExpose User Prompt and Agent Response Logs for Fabric Data Agents
Idea: As an engineer responsible for managing and improving Microsoft Fabric Data Agents, I currently have no way to view how users are interacting with the agents I’ve built. While it’s likely that...JoshuaPitzer17 hours agoAdvocate INew1.2KViews26likes2Comments