Forum Discussion
Importing from One drive
- I would suggest if you have to use the Autofills then to possibly create another sheet, which then is a copy from your first sheet. Then on your copy because it is just the data, you can then create that as a table?
Got it ! is it the same case with Sharepoint too. I mean, if i try to get the data from power Bi service from sharepoint online, it has to be in table format is it? or i have to import the data onto power bi desktop create dashboards, publish it to power bi serrvice. But how can i automated the dasboards ?
Thanks,
Pranitha
I have not tried from SharePoint Online directly into the Power BI Service, but anything that is being imported from an Online source would need a table type of structure so that Power BI knows what to import (when to start and stop with the dataset)
Got it ! is it the same case with Sharepoint too. I mean, if i try to get the data from power Bi service from sharepoint online, it has to be in table format is it? or i have to import the data onto power bi desktop create dashboards, publish it to power bi serrvice. But how can i automated the dasboards ?
Thanks,
Pranitha
I have not tried from SharePoint Online directly into the Power BI Service, but anything that is being imported from an Online source would need a table type of structure so that Power BI knows what to import (when to start and stop with the dataset)