Power BI Tutorial: 4 Ways To Get Data
Vložit
- čas přidán 18. 08. 2024
- In this Power BI tutorial, Adam looks at 4 ways to get data in Power BI. This focuses on Power BI Desktop and the main storage modes - Import, DirectQuery and Live Connections to Analysis Services. If you are new to Power BI, be sure to check out this Power BI Tutorial: 4 ways to get data.
Import (Excel) [01:46:21]
Import (SQL) [04:28:17]
DirectQuery (SQL) [06:48:07]
Live Connection (Analysis Services Tabular) [10:10:08]
Service/Push/Streaming [12:13:20]
DirectQuery Documentation:
- Whitepaper: blogs.msdn.mic...
- Data Sources: docs.microsoft...
- Limitations: docs.microsoft...
- Kasper de Jonge's Blog regarding Performance: www.kasperonbi...
LET'S CONNECT!
Guy in a Cube
-- guyinacube.com
-- / guyinacube
-- / guyinacube
-- Snapchat - guyinacube
-- / guyinacube
**Gear**
Check out my Tools page - guyinacube.com... #powerbi #guyinacube - Věda a technologie
Hi Adam
We’ve recently set up a full MS data warehouse stack. We replicate Dynamics 365 online to Azure and four times a day run Azure Data Factory to populate an Azure SQL data warehouse. After watching Patrick’s video on data silo’s we decided to use Power BI to define subject area models which we publish to the Power BI Service, and from there use live connection to build/publish Power BI reports.
Sure there are some considerations with this approach, but it’s a pretty sweet set up. It gives us control of the back end, a consistent shared model and it suits our users really well.
I appreciate all that you and Patrick do for us and the community.
Awesome! Thanks for sharing Tim! That is a great approach. 👊
Nice Tutorial for Get Data.
I like all way, Nice Import with PowerQuery, Nice DirectQuery with SQL Server and Azure SQL Database, Nice Connect to Power BI Service on small PC, Nice Streaming Dataset for real-time update scenario.
love it! 👊
Hi Guys !! Thank you for giving so cool information about PowerBI. I am a beginner in PowerBI but a expert in Tableau , want to master PowerBI as well. Can you guys please make a video on da-100 beta certification , is it worth appearing in beta version or shall we wait ?
Also , if you can post some videos where can we practise on PowerBI service for free . Thanks again !! Keep rocking !!
Quite comprehensive mahn. Cheers!
Nice and simple explanation 👌
very nice overview using direct query for most cases, could be analyse service could be actual i the longer therm
Nice! Are you hitting any performance issues using DirectQuery? How big is the dataset?
I'm looking to have data refreshed on a daily basis in Power BI from an SAP data source. Is direct query the right method to or is this function not available in Power BI?
Thanks Adam!
Great explenations!
Thank you! and thanks for watching! 👊
@@GuyInACube
Hey thanks.
Great tutorial!
Just wondering how to link powerbi online with database server.
Can it be done easily just like what you have shown in this video or does it need any written code (M language) to get the job done?
My boss just wants the powerbi online to sync with database daily.
We are almost 100% Import to take full advantage of all the Power BI features/functionality available. We do have some live connections to power bi datasets for consistent yet agile reporting without duplicating work; however, those datasets always start off as imports.
Hi Adam! For me another very interesting way to get data in Power BI is to use Flow. I do that for example to pick tweets from twitter or videos on you tube and push them to a dataset. Would love to be able to push to datapool (CDS-A) directly though!
Yup that is a great use of flow. That falls into the Push/streaming dataset option I talk about. Pushing to a datapool is a little different as the datapool isn't a dataset. More of a data warehouse. i'm sure there are ways you could potentially push to a datapool, or at least the underlying storage. Intereting thought. 👊
Hi Adam, The data size is getting more than 1 GB and i am using Power BI pro license, is there anyway i can do something where i can change my approach in loading data from FILE to power BI may be parameterizing ?( i dont want to use premium license and Analysis approach )
Hi!
this was a good explanation, but I believe the most widely used model today is importing, but I believe that directquery is important in some cases. it would be a good idea to explain how updating scheduled importing works with one permission gateway.
Thanks for the video ;)
Hi, what if I change the name of the excel but it contains the same structure? Does it work when I refresh?
thanks.
Q: I have made a power bi file several months ago that includes several different files and now i can't find one of my imported sheets. How can i find it?
awesome as always, how can i get live stream visuals and dashboard by using azure sql database ? i have tried direct query for now but it takes atlist 15min to refresh data. is there any other solution that get me data refresh rate as much faster ?
Hi Adam,
Nice video as always - I was just wondering, was there any mention of query folding? it would be create to have a cheat sheet to show the pro/cons of each connection type
Please keep up the GREAT work :-)
Thanks Mathew! I didn't get into that specifically in this video. Wanted to keep it high level for folks just starting out. Don't want to scare them with things like Query folding 😉. Teo Lachev has a great blog post talk about the differences between the different methods. A video around this / Pros & cons is a great idea though.
prologika.com/power-bi-feature-discrepancies-for-data-acquisition/
Cheers Adam your a star - I'll keep my eye out for it :-)
How we schedule refresh in PowerBI if my data source in HDFS? In live connection when I connected to Azure HDInsight then we can schedule refresh in 15 minutes but can we do the same when my data source is HDFS?
I was waiting to here about the R script option. I need to do a better job of getting the word out about that extremely valuable but very underused feature in Power BI:-)
🙂 Yeah. This was more high level for someone just starting out. I don't know that an R script would necessarily fall into that bucket. Keep pushing the R love Ryan! 👊
hi
i would like to know why am getting error when im trying to get data from power bi dataset when am working on a workspace with excel dataset?!$%
do a data scientist/analyst make application for user too or just proccess the data and user just get the result?
Hi Adam
May you please help by creating a video that shows us how to connect Power BI to the Facebook graph API and extract data from it. Been trying to do that for the whole day to no avail.
Thanks for the suggestion. I can put it on the list.
I have a question:
I am using powerbi in my company with direct query but the limitation with direct query is the if powerbi gateway service is not running that our users are unable to retrieve data and reporting shows the error message.
Is there any possibility that we create a schedule that update the dataset of powerbi. So when user check the report or dashboard it will bring data from powerbi cloud dataset which will be updated by the scheduler after every particular interval.
Regards, waiting for your response. thanks
Hi
Dual storage supports Referential integrity?, as direct query support it??
Is direct query available for cds/d365?
hi Adam
I have a problem, i am trying to make an automatic power BI which should get the data from any source (excel, sql, access DB) of course with the same format of data tables(columns and/or querys) and make the same kind of charts or diagrams, could it be possible?
it would be so nice iof you could help me out.
Hi
Could you please please tell if I have set all my direct query to dual storage, how will be my report performance???
If all your tables are dual, chances are you would stay on the import side of things and never hit the DirectQuery side. So, in that sense, probably fast. When it comes to performance, always, always test and compare. It can vary depending on the data profile and size.
Hi Adam, I have a question for you. Please let me know if you have an answer.
I am trying to schedule refresh an excel file which is on cloud using power BI. The excel file has O'Data connections to get the data. Is it possible to refresh the queries in excel when I schedule refresh it in power BI. what I am asking is: if there are any data changes in external source(O'data) can the data data in excel be updated when we schedule refresh the same file in power BI.
We built an excel pivot report connected to an excel series of Power Queries, then use a little VBA to refresh the pivot tables (if between a certain timing window) save and close the file. We then use a DAT file to open the excel file via the task scheduler
how to bring in 13 mil rows from oracle?
Import - every time 😃
Thanks Wyn! I definitely lean that way. There is a time and a place for each though. 👊
Depends on your role. I prefer to create a model and have my users do a live connection. That way I'm sure they're using the correct measures and relationships.
Can you tell me a way to connect PowerBi with FireBase?
FireBase is not a connector that ships with Power BI. You would need to check on how they allow connectivity. Power BI allows for ODBC/OLEDB connectivity. Or, if they allow for OData access, you could use that as well.
Hi All,
In same colums has differnt Data like Text,Numbers,% etc.. When ever i import Data 85% becoming 0.85 .
i want to import data without any change through import option,so that i can refresh in future
Thanks in Advance
You can alter the formatting after the import. Can be done on the data model side so that it is treated as a percent.
@@GuyInACubeIn same column I have charcters, numbers, % etc.. ,so the rest of data giving as error.
Thanks in advance.
@@younissyed9259 You are in for a touch spot if your column represents different types of data. You could look at restructuring the data model to accommodate. If you have mixed values, leaving the model the way it is, you don't have a ton of options. You could use a measure to extract the items and then do formatting on the measure, although that could lead to perf problems. I recommend fixing the data from a model perspective.
Can I live connect a excel data source?
No. Live connect is specific to Analysis Services. Only import is supported with Excel
@@GuyInACube Thank you!
Import from SQL