How to sync Excel data with Microsoft Fabric on a certain interval?
Hi Team, I have used this custom visual to create the following chart in my Power BI dashboard. The survey data is currently stored in Microsoft Excel but we want to push it to Microsoft Fabric after every survey and wants to run the dashboard from the Fabric. What is the best way to push data from Excel to Microsoft Fabric at a certain interval? What would be the cost involved in using Microsoft Fabric for this use case? thank you.
Joining Salesforce Data to Excel Sheet Data
Hi everyone! I am looking to see if PowerBI supports joining two unrelated data tables into one project. I want to pull in data from a Salesforce sandbox, as well as an excel sheet. I then want to join this data into one table. I was able to do this with Tableau, so I'm hoping PowerBI has a way!
How to change the data source of a model and run the existing queries?
I created a model based on excel file. after connecting to the data source (which is the his excel file) I created several steps and measures. Now I realized that it could be better to used a pivot table (which is in anotehr excel file) as a data source, instead of the first excel file. The layout is the same in both excel file and pivot table file (1st and 2nd file). When I change the data source to the pivot table excel file, it gives me error and I cannot connect it properly nor use the steps that I created beforehand. Error presented when trying to load new data source: "The key don't match any rows in the table". How to make that? Thanks, Diego
Custom Visuals for Excel Now in Preview!
Custom Visuals for Excel Now in Preview! Custom visuals for Excel is starting to roll out in preview to Office 365 subscribers enrolled in the Office Insiders program! Try It Out and Give Us Your Feedback We are continuously building on the experience in preparation for release to all Office 365 users. We want your feedback on how to make this a better experience for developers and end users. CLICK HERE GET STARTED
