Or just create an "import query mode" report and create a flow with "When an item is created or modified" trigger and "Refresh dataset" action. Includes every type of changes and it is working like a charm.
Great tutorial video. Was able to finally pull my data from the SP to a PBI report directly - which is near-real time :) Just amazing. One aspect didn't work in my case. It didn't pull the initial data from the SP. Although it is fine in my case, as the data I have is for only for training purposes, this might present an issue for anyone out there with the existing data records they want to preserve and pull to the streaming dataset. Anyway, thank you very much.
Hi Rashid, It is humble request to would you please guide or make video to show records more than 2 Lists to Power BI Report. Much appreciated your kind help and support.
That is really easy, you will need to connect Power BI report to multiple lists. If lists are related then create a relationship using Power BI desktop user interface. I will add this topic to me to do videos list.
Yes, you can connect to document library to fetch metadata too. Just use the SharePoint Online List connection from Power BI and you will see the document library in the list of selections.
Great Tutorial. I am an intern working for a Renewable Energy Company and I have been tasked to create a PnL Dashboard that can automatically be updated whenever the files are updated with new rows. We do use share point at my organization but I am not quite sure on how I create relational Database to automatically update in power BI.
Hi Rashed Thank you very much for your demo, it was realy easy to follow along and it works . Big thanks:). I have two issues 1. when i delete a row on the sharepoint list, it still retriving the same data 2. when i update a status (i have status field ongoing, paused, finished) on the sharepoint list, it does not update. I know you mention early in the video about the update. Are you gonna make a video about update, or do you know where i can find information to add this to the power automate?
@@KeaPointTechTips : Please let me know if you have any video for writing a custom connector to get update on the records and delete it from the SharePoint data set. Basically, it will be helpful in Power BI real time reporting from SharePoint list.
Hello, thank you very much for the helpful video. I was wondering if you have covered another topic similar to this one but with row update and deletion using Power Automate?
Nice video Sir, Can you please tell how to automate the downloading of Reports from Power bi service instead of downloading manually and store in Share point.
There are two things that didn't work out for me 1) When I use streaming datasets in a report I'm not able to use any other source. 2) I am not able to create custom columns.
This example covers only the basics of one list to streaming dataset scenario, You will need some kind of ETL process in the middle to combine data from multiple resources and add any additional columns you may have.
Hi, Is there a way where we can create a list in SharePoint with data that has been created powerbi table (dataset) with all calculated columns included using flow? More of the reverse process that has been explained here.
If you are referring to the dataset in Power BI Service, I'm afraid there is no way to do it with the Power BI connector, it only supports to add a row and refresh data.
Hello! This is very helpful. The problem that we have is when you are editing data that is already in the streaming data set he will keep the original and add new edited rows, so you will have 2 rows for the same ID. Is there a way that you can remove all rows from a streaming data set and then push new data using Power Automated?
@@KeaPointTechTips Hi Thank you for the replay. We have tried, but we need to use dataset ID because the refresh dataset action is not finding that dataset automatically, with ID working but the data still stays in the dataset and has not been deleted, and that is what we want to empty the dataset before next push of data.
Great video!! How can we transform the data? viewing the data in table view is not possible in Power BI, I have a percentage column that I would like to present in percentage but so far it can only be a decimal number (e.g. 0.5 instead of 50%) also I can not remove the thousands delimiter from the column "Year" which I defined it to be a number field in the streaming dataset. Can you help please?
Hello! Thanks for the video! I'm wondering, is it possible to do it the other way? I mean, create a list in SharePoint from PowerBI data and update the list when the data changes in PowerBI Cheers!
@@KeaPointTechTips Hi thanks for your answer. It's a temporal workaround, as I need to feed a Microsft Access Database with data from Power BI and I want to use de SharePoint List connector in Access. I know is odd but right now is the only alternative I have.
It is easier to create with Power Automate; when a new Item is created in the SP list, just refresh the Power BI. Just write it with natural lenguage in the Power Automate and it will create automatiically that flow for you
Can you elaborate on that? The Refresh command in Power Automate is not showing the report/dataset I want to refresh. It does not work with all datasets.
It will only work in Power BI desktop not Power BI online. You will have to click refresh button in Power Bi desktop to refresh the dataset from the source.
Or just create an "import query mode" report and create a flow with "When an item is created or modified" trigger and "Refresh dataset" action.
Includes every type of changes and it is working like a charm.
hits a daily limit of refresh so it basically prevents you from creating real-time dashboard
But limit of 8 updates still applies. The flow will fail if limit of 8 is exhausted for Pro users.
Great tutorial video. Was able to finally pull my data from the SP to a PBI report directly - which is near-real time :) Just amazing. One aspect didn't work in my case. It didn't pull the initial data from the SP. Although it is fine in my case, as the data I have is for only for training purposes, this might present an issue for anyone out there with the existing data records they want to preserve and pull to the streaming dataset. Anyway, thank you very much.
Glad it helped Anastasia, You may want to explore direct query with Dataverse instead of SharePoint list
It worked like a charm for me. Thanks KeaPoint.
Great to hear!
i don't understand why we can't use sharepoint list as datasource w. a power automate flow to refresh dataset
You can, but we can only refresh data 8 times. to achieve near real time we need to adopt this approach.
Hi Rashid, It is humble request to would you please guide or make video to show records more than 2 Lists to Power BI Report. Much appreciated your kind help and support.
That is really easy, you will need to connect Power BI report to multiple lists. If lists are related then create a relationship using Power BI desktop user interface. I will add this topic to me to do videos list.
Hello! This is very helpful 🙏🏻 Does this functionality also works for data within SP library or only for SP list?
Yes, you can connect to document library to fetch metadata too. Just use the SharePoint Online List connection from Power BI and you will see the document library in the list of selections.
Great Tutorial. I am an intern working for a Renewable Energy Company and I have been tasked to create a PnL Dashboard that can automatically be updated whenever the files are updated with new rows. We do use share point at my organization but I am not quite sure on how I create relational Database to automatically update in power BI.
If you share more details, I would be happy to assist.
Thanks a lot! You really helped me out😀
You are welcome!
This helped, however need more advise on how to remove a specific item from the streaming dataset, is it possible?
I have not tried it, can you explain the business case for it?
Great tutorial video
Thanks.
This is awesome
Thank you
Hi Rashed
Thank you very much for your demo, it was realy easy to follow along and it works . Big thanks:).
I have two issues
1. when i delete a row on the sharepoint list, it still retriving the same data
2. when i update a status (i have status field ongoing, paused, finished) on the sharepoint list, it does not update.
I know you mention early in the video about the update.
Are you gonna make a video about update, or do you know where i can find information to add this to the power automate?
Thanks. You will have to write a custom connector to get update on the records and delete it form the data set. I will make a video on it soon.
@@KeaPointTechTips Thanks. Do you mean by using data/coustom connector/new coustom connector in power automate?
Hi, did you get solution for your question , could you share
@@KeaPointTechTips : Please let me know if you have any video for writing a custom connector to get update on the records and delete it from the SharePoint data set. Basically, it will be helpful in Power BI real time reporting from SharePoint list.
Hello, thank you very much for the helpful video. I was wondering if you have covered another topic similar to this one but with row update and deletion using Power Automate?
Change item limit in the flow get items action step.
Thanks for sharing! 👍
No problem 👍
Nice video Sir, Can you please tell how to automate the downloading of Reports from Power bi service instead of downloading manually and store in Share point.
There are two things that didn't work out for me
1) When I use streaming datasets in a report I'm not able to use any other source.
2) I am not able to create custom columns.
This example covers only the basics of one list to streaming dataset scenario, You will need some kind of ETL process in the middle to combine data from multiple resources and add any additional columns you may have.
Great video! Can we create a report using Power BI Service without Power BI Desktop?
You mean by just using power BI web portal? Yes, you can.
Hi, just want to check if you have uploaded the video on how to set a flow in power automate when we update/delete data in sharepoint? Thanks!
I haven't, sorry.
Hi, Is there a way where we can create a list in SharePoint with data that has been created powerbi table (dataset) with all calculated columns included using flow? More of the reverse process that has been explained here.
If you are referring to the dataset in Power BI Service, I'm afraid there is no way to do it with the Power BI connector, it only supports to add a row and refresh data.
Hello! This is very helpful. The problem that we have is when you are editing data that is already in the streaming data set he will keep the original and add new edited rows, so you will have 2 rows for the same ID. Is there a way that you can remove all rows from a streaming data set and then push new data using Power Automated?
have you tried refresh dataset action of power automate?
@@KeaPointTechTips Hi Thank you for the replay. We have tried, but we need to use dataset ID because the refresh dataset action is not finding that dataset automatically, with ID working but the data still stays in the dataset and has not been deleted, and that is what we want to empty the dataset before next push of data.
Great video!!
How can we transform the data? viewing the data in table view is not possible in Power BI, I have a percentage column that I would like to present in percentage but so far it can only be a decimal number (e.g. 0.5 instead of 50%) also I can not remove the thousands delimiter from the column "Year" which I defined it to be a number field in the streaming dataset.
Can you help please?
Check your columns data types in power query. Looks like the data types are not set up correctly.
V nice
Thanks
Is it possible to send the data from power BI to sharepoint list?
Yes, it is possible via Power Automate flow. I have a video on this topic in my to do list. I will prioritise it in the coming days.
do u faced the problem of date not matching if u use sharepoint as datasource in power bi ?
Hello very good video how do you delete PowerBI on sharepoint website under "Visualize the list?
Hello!
Thanks for the video! I'm wondering, is it possible to do it the other way? I mean, create a list in SharePoint from PowerBI data and update the list when the data changes in PowerBI
Cheers!
Hi, Power BI is mainly used for data visualisation. I want to understand the business requirements here.
@@KeaPointTechTips Hi thanks for your answer. It's a temporal workaround, as I need to feed a Microsft Access Database with data from Power BI and I want to use de SharePoint List connector in Access. I know is odd but right now is the only alternative I have.
You can use PowerApps and connect it directly to Access, or migrate data to SharePoint.
Hi!
Great video...
Just wanted to know can this method be implemented for getting real-time data from MSP Online as well?
Thanks!
Never tried on MPO. I think possible.
Sir how to integrate MIS with power BI for real time data??
What MIS system are you trying to connect via Power BI, check if teh connector for Power bi is available for teh targeted MIS.
It is easier to create with Power Automate; when a new Item is created in the SP list, just refresh the Power BI. Just write it with natural lenguage in the Power Automate and it will create automatiically that flow for you
Can you elaborate on that? The Refresh command in Power Automate is not showing the report/dataset I want to refresh. It does not work with all datasets.
@@IngeborgHawighorstI'm also failed setting scheduke refresh dataset from sharepoint using web connection
If you update a record will it show up and power VI if you refresh the Power BI page?
I have mentioned this at the start of video, this only works if you are adding records. For updates you will need to write logic in custom connector.
@@KeaPointTechTips Could you make a video on this
Can i etl bofore load?
Power BI is not a dedicated ETL tool, but Power BI does come with a built-in user interface to get and transform data using Power Query. Give it a go.
hi, if we don't power automate it, and update the list, will it still work ?
It will only work in Power BI desktop not Power BI online. You will have to click refresh button in Power Bi desktop to refresh the dataset from the source.
@@KeaPointTechTips Thank You