Is there a way to connect SharePoint and Power BI so that there’s a live data connect for real time updates?

like
Posting as :
works at
You are currently posting as works at

Yes, you’ll need admin access on both sides though.

like

Also believe you need powerBI pro and it's in the gateway section.

like

So not "real time"

To load data to power bi from SharePoint, you have to use "import" mode, where the data is loaded to power bi's internal database. These loads take minutes, but milliseconds, so there are limits in how often you can do them.

Power BI Pro supports 8 refresh a day.
Reports in a workspace backed by a premium capacity or a premium per can support unlimited refreshes per day via Api or 48 via the UI.

Power bi can get near real time refresh using Direct Query mode, when the data is in sql or another data source that has a robust query engine so it can evaluate all the logic needed to build each visual (and not just a big table). Unfortunately SharePoint can't do this. There are also downsides to this mode: it's generally slower, each visual sends a query each time you interact with the report, so your server better be up to the job.

You don't need a gateway for SharePoint online. However if you are using an on prem SharePoint server, you will need a gateway to enable powerbi to work with your firewall.

The threading got a little messed up, but to be chat: yes

Related Posts

Moving to the area for work and was wondering if I live off of the San Bernardino metrolink line, when I bring the train in to Union Station and then transfer to the LA metro system, will I end up ...

Hey fishes, pls help me unlock DMs. Thanks!

like

How to deal with an overly paranoid family member? I've been working from my parents place for the past month and my brother recently came home for the holidays. Out of all of us, my brother is the most cautious, but to the point where he is paranoid. Like, he will wear 2 masks, doesn't see anyone, uses hand sanitizer after touching anything (like his shoelace), and doesn't use grocery store baskets (holds everything). I respect his habits and I've been pretty cautious (cont. in comments)

likefunny

How are SAP projects in PwC?
I have Accenture and PwC
Pls suggest

like

Anyone have an idea what the pay range for Capgemini Senior Consultant is for outside London? Is £70k considered higher end or mid?

like

The job market seems slow right now, who is hiring in the city?

like

What are Google Canada email addresses?

funnylike

Any recommendations for international relocation companies? We'd be moving from the midwest back home to the UK. Any other advice for a transatlantic move would be much appreciated!

like

Hello,
Anyone here from the @EY Mumbai location?

like

Waiting on Yale emba for round 2. Anyone else in same boat?

Wondering what your Salary and Bonus (TTC) is and what Tier/ Level and location are you in.

I’m a senior associate and received an offer to join a very profitable client as general counsel that would open lots of doors professionally and financially. Problem is I’m super burned out on law and was planning on quitting law firm in the next few weeks and doing something else with my life. Someone kick some sense into me before I decline the offer.

like

Hello Fishers

I have completed all the rounds with Wipro Tech.its more than week now, offer letter is not received.

I got an update from HR coordinator that it's waiting for approvals.

Is it the Answer we can expect from HR if I am rejected.

Thanks

like

Looking for jobs in Illinois in public low income schools for 2022-2023. Any leads?

like

Break even for $2. Well worth the pour!

Post Photo
like

Hey London fishies. Hopping across the pond in the new year. Who are some good recruiters in the city, and is there a London ad job Facebook group or something I can join?

like

Has anyone had any experience living at 425 Mass?

like

She was very sleepy...

Post Photo
like

My spouse and I are buying our first house soon and we are thinking of renting out a room. Anyone who is currently doing this or has done it before? Would you recommend it or is it too much of a headache?

like
like

Additional Posts in Excel Genius

Can I write a macro that will fill out a table of information based on cells that have comments on them? For example, if G12 has a comment, I want to pull text from that comment + data in A12.

like

I’m trying to go back to the basics. How do you guys structure thoughts around identifying the correlation between 2 variables? A basic example: the number of steps I take in a day and the hours of sleep I got that night.

like

Google Sheets vs Excel - pros? cons? differences?

likefunnysmarthelpful

How do I stop excel from changing the cell reference to a different column each time I refresh the data pull?
The spreadsheet is connected to an API data pull. Each time I refresh the data it changes the cell reference (SCD_0010) to a different cell e.g. (SCD_0127). How can I stop this?

Post Photo
like

Why when I refresh a query, the table where the query is loaded to just gets duplicate rows? Same with the pivot table that feeds off of that query?

like

I want to create a heat map of when people are unavailable with day of week as the columns and hour of day as the rows. I have start times and end times, how can I use this data to create the map?

like

Does anyone know how I can conditionally format a table with a sliding scale? I have a value that is supposed to fit in a range. I need the first possible range the number can fit in to be formatted. Thanks

likehelpful

I’ve toggled the “Show Formula” setting and it changes nothing. File format is xlsx, so that shouldn’t be the issue. Any ideas why these are showing the formula instead of the output?

Post Photo
like

Last cell question. Some of my simple models are massive in file size because every tab has a last cell of ~XFD65. But I’m not using anything past ~U100. Continued.

like

Any recommend courses (coursera, edx, etc.) people would recommend for user with intermediate experience with excel?

like

If you follow him on LinkedIn you probably already saw this! Lol 😆 but I totally resonate with the post... 🤣

Post Photo
funnylike

At my old firms when I would be using excel and modeling using the font schemes (blue, green, black for hardcode, link, and formula) I could use the “control shift ;” to shift through the schemes. My new firm doesn’t do this. Does anyone know why the shortcut would be different and how I can add it back?

like

Our system is really lacking and we do a lot of work outside of it to track data. Currently I’m using Excel to track data from multiple resources, however, it’s so manual and prone to error. Any suggestions to keep the data clean when I have to pull info from multiple places? I’m constantly auditing and we won’t even look at getting a new system until next year :(

What is y'all's preferred clipping tool? One of my former companies had a great simple program that was only like $50 and worth every penny.
Snipping Tool just ain't cuttin' it (lol pun intended).

like

Hi team i have a bit of doubt.
I have an excel sheet where column A is the order numbers. I want to add comments in column G.
There are many repetitions in order numbers but they are all sorted in ascending so all the repetitions are below one another.

If i have a comment, how can i automatically paste that same comment in all the repetitions of that order numbers if i write it in the 1st instance.

Thanks in advance

like

Hi! I have knowledge of pivot tables, vlook ups. But I'm rusty on if statements and would like more knowledge on excel formulas. I'm looking for excel classes to take online. Any suggestions?

like

I have three lists. Each is a list of processes. Each list represents one hierarchy level. Is there an easy way to get from three separate lists to one list ordered like shown on the right?
Thanks for your help fish!

Post Photo
like

What are the most typical models you all build

likehelpful

Is Macabacus or any other add-in actually worth it for Excel & PPT? In LMM - MM M&A roles.

likehelpful

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal