Bulk export/import of Planning input measures with Date on columns

Started by AlexBartlett · 3 weeks, 2 days ago · 2 replies · 131 views
AlexBartlett Participant
3 weeks, 2 days ago

Hi,

I have a Fabric Planning Sheet using the measures in rows layout with:

For example:

I need users to bulk edit this data, ideally by exporting a template, changing values, and importing it through PowerTable.

The issue is:

  • Excel export contains the Planning input measure.
  • CSV export gives me the vertical SKU + Date structure I want, but doesn't include the input measure.
  • InfoBridge can produce exactly SKU/date/Input Measure, but I can't see how to expose/export that query through PowerTable or automatically keep a PowerTable populated from it.
  • I don't want a second Planning Sheet/input measure because that creates another copy of the data to synchronise.

Ideally I need:

Is there a supported way to synchronise a PowerTable from a Planning input measure or InfoBridge query, or otherwise provide an exportable bulk-edit template containing the current input-measure values?

Many thanks,

Alex

2 Replies
Aparna JegannathanLumel Staff
Lumel · 3 weeks, 1 day ago

Hi Alex,

We have received your query and shall get back to you soon.

Gopal KrishnamurthyLumel Staff
Founder/CEO · Lumel Technologies Inc · 2 weeks, 4 days ago

It is in our immediate roadmap and we have started working on it. The bulk input capability will be more robust/comprehensive than what we had in Inforiver WB Matrix.

Viewing 2 replies - 1 through 2 (of 2 total)

About this topic

  • Replies 2
  • Views 131
  • Participants 3
Microsoft, Azure, Copilot, Excel, Fabric IQ, Microsoft Entra, Microsoft Fabric, Microsoft Teams, OneLake, Outlook, Power Automate, Power BI and SharePoint are trademarks of the Microsoft group of companies. IBCS is a registered trademark of IBCS Association. All other trademarks are the property of their respective owners.

This community is operated independently by Lumel. Nothing on this site constitutes a representation or warranty by Microsoft.