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.
Hi all,
I have a doubt
Due to some constrain, i cant able to use OneDrive, so i had created .pbix using SharePoint excel data source. Now, i was bit confused, do i need gateway or not
Any help is appreicated
Solved! Go to Solution.
@vijayvizzu if you do any changes to the excel file in sharepoint online then the data will be updated you dont have to republish the pbix
OR
You can also make use of schedule refresh option in power bi service
Note:If you are using onpremise source and dont want any gateway configuration you will have to republish the file even for a small change and i wont suggest this as it take lot of manual intervention
Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos, Press the thumbs up button!!👍
@vijayvizzu If you are saving the excel in Onedrive or Sharepoint online then you do not need gateway configuration .It depends from where your source(excel) is coming if its onpremise like desktop then you will need gateway configuration...
Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos, Press the thumbs up button!!👍
Thank you for the update.
In this scnerio, if i will update the .pbix (locally saved file), will it automatically update in the power bi service or do i need to re-publish it again ?
@vijayvizzu if you do any changes to the excel file in sharepoint online then the data will be updated you dont have to republish the pbix
OR
You can also make use of schedule refresh option in power bi service
Note:If you are using onpremise source and dont want any gateway configuration you will have to republish the file even for a small change and i wont suggest this as it take lot of manual intervention
Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos, Press the thumbs up button!!👍
Proud to be a Super User!
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.