Report Pundit
WelcomeStart Free Trial
  • ✨Welcome to Report Pundit Documentation
  • 🏡Report Pundit Website
  • 💻Report Pundit App
  • 🛒Shopify Testimonials
  • 📌Getting Started
    • 👨‍🏫Walkthrough
    • ℹ️Navigation Panel
    • 🏠Home
    • 📔Library
    • 💼My Reports
    • ⏰Schedules
    • ⚙️Settings
      • 🪪Account
      • 🔁Data Sync Options
      • 🛠️Report Formatting
        • 📅Week Start from Sunday
        • 🌕Include Current Day
        • 💲Enable Currency for Reports
      • 📀FTP, Google Drive, and Google Sheets
      • 🌀Recent Sync History
      • 📬Custom Email
      • 👥User Management
      • 🤵‍♂️Shopify staff
    • 🧩How to Create a Custom Report and Auto-Schedule It
  • 🧠Knowledge Base
    • 🧾Report Creation
      • Customized Reports
        • Re-arrange columns
      • Filters
        • 'Contains' & 'Not contains'
        • 'Is' & 'Is not'
        • 'Include' & 'Exclude'
        • 'is Blank' & 'is not Blank'
        • 'begins with' & 'ends with'
        • '= Equals' & '!= Not Equals'
        • '> Greater than' & '< Lesser than'
        • '>= Greater than or equal' & '<= Lesser than or equal'
      • Sort
      • 🖌️Custom Fields
        • Calculated Columns (Fields)
        • 🛡️Static Field
      • Data Comparison
      • Formatting Tools
      • Sharing Report Links
      • Exporting the report
      • Unique Reports
      • Staff Details
      • Other Options
    • 🔗App Integrations
      • Stocky
      • UpPromote
      • Yotpo
      • Sezzle
      • Square
      • PayPal
      • Google Analytics 4
      • Amazon Ads
      • Bing Ads (Microsoft Ads)
      • Facebook
      • Snapchat
      • TikTok
      • Ship Bob
      • Ship Station
      • Ship Hero
      • Bold
      • Printful
      • Printavo
      • Authorize.net
      • Recharge Payments
      • Klarna
      • Shippo
      • Returnly
      • Rich Returns
      • Seal Subscriptions
      • Google Ads
      • Stripe
    • 📥Schedules
      • ⌚Hourly
        • "N" Number of Days
        • Week to Date
        • Static Start Date
        • Custom Date Range
      • 🌞Daily
        • Custom Time Range
        • Custom Date Range
        • Static Start Date
        • Year to Date
        • Quarter to Date
        • Month to Date
        • Week to Date
        • "N" Number of Days
      • 📆Weekly
        • Year to Date
        • Quarter to Date
        • Month to date
        • "N" Number of Days
        • Static start date
        • Custom Date Range
      • 🗓️Monthly
        • "N" Number of Days
        • Quarter to Date
        • Year to Date
        • Static Start Date
        • Custom Date Range
      • 🕞Schedule Modification
      • 🔽Output Options
        • Email
        • 📤FTP
        • 💽Google Drive
        • 🗒️Google Sheets
        • Power BI
        • BigQuery
    • 📃Report Types
      • 🤵Sales
      • 🥡Orders
      • Inventory
      • 🎁Fulfilment
      • Customer
    • 🔄Data Synchronization
      • How to Manage Your Data Mismatch Issue
  • ❓FAQ
    • Reports
    • Schedules
    • Data Sync
    • Billing & Sales
    • Service
  • 📋Changelog
Powered by GitBook
On this page
  1. Knowledge Base
  2. Schedules
  3. Output Options

Power BI

Combine Report Pundit’s powerful reporting with Power BI’s powerful data analysis and visualization capabilities automatically to gain deep, clear insights about your Shopify store.

PreviousGoogle SheetsNextBigQuery

Last updated 1 year ago

Now, you can do more with your Shopify store data while also saving time. And all it takes is just a few clicks.

Simply set up Report Pundit's Schedule feature to automatically export your reports to Power BI in your preferred file format.

(If you haven't connected your Report Pundit and Power BI accounts yet, click).

How To Export Files to Power BI

Once your Power BI account is connected, you can send your files to it easily as shown:

  1. Schedule report generation via Report Pundit. (Click to learn about report scheduling).

  2. In the final Output Options stage of scheduling, choose the report's destination as Power BI by clicking on the respective option in the tabs panel.

  1. Select your preferred Dataset and Table options in the respective dropdown menus. You can also create a new Dataset or Table by selecting Create New from the dropdown list.

  2. Then, choose to Append or Overwrite any existing Power BI data with the new set according to your preference.

  1. Click on Export in your Power BI dashboard to reveal a drop-down list with available file formats. Select your preferred format to export the data.

If you need any more help with this, just or click on the chat box anytime. Our expert staff will be with you quickly to resolve the issue.

🧠
📥
🔽
contact us
👉
here
here
Finding Power BI during report scheduling
Scheduling and Choosing the report's destination
Screenshot of Power BI's export formats