Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I'm fairly new to Power BI, so apologies if this is a stupid question.
I've been able to build dahboards to date for 'one-off data', however I would now like to create a dashboard which will update according to a fairly contuous data collection. So for example, I will be setting up a dashboard to reflect the current status of a Investment Fund (e.g. money disbursed, money received, performance of clients etc). I can do this for the data I have at this present moment. However, this data will need to be updated on a monthly basis.
Sources of data will be Google Forms and data from Salesforce.
So my main quandry is:
Really appreciate any guidance any one can give here.
Best wishes, Greg
@Gregwoolley2387,
Firstly, is there any possiblity that you transfer the data from Google Forms to Google sheet? You can connect to Google sheet in Power BI Desktop following the guide in this similar thread. In the same Power BI Desktop file(PBIX file), you can import Salesforce data using Salesforce object connector.
Secondly, what role do you refer to? In Power BI Desktop, you can configure Row Level security.
Thirdly, when you import data from data sources into Desktop and create report in Power BI Desktop, the consolidated data is stored in the PBIX file. If you publish the PBIX file to Power BI Service, Power BI manages the storage of data and metadata using Azure BLOB and Azure SQL Database.
Regards,
Lydia
Hi Lydia,
Thank you for taking the time to respond, really appreciate it!
1. Yes definitely, we will be using Google Sheets. I should have written that will be taking the results from Goofle Forms into Google Sheets. And thank you for the note on the Salesforce Object connector.
2. By 'role' I was trying to work out whether the Query Editor could be used to automate the manipulation of the 'raw data' flowing through from Google Sheets and Salesforce. (The reason I ask this is because the data from Google Sheets and Salesforce will not be 'Power BI friendly', i.e. it will be in a large 'cross table'. My understanding is that teh dataa needs to be 'flat data' to be easily compatible with the majroity of chart sin Power BI.
3. Thank you this explanantion.
Look forward to hearing from you on any other help you can offer.
@Gregwoolley2387,
I am not sure what is the cross table like, but you can transform and shape data in Power BI Desktop query editor.
Regards,
Lydia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.