Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I downloaded and set up a Gateway and then, in PowerBI Online, I added a Data Source pointing to an Excel file saved in Dropbox. I made sure the file sharing settings were such that "anyone" with the link could view/edit.
But now I'm stuck.
I don't see that excel file/data/dataset/whateverthedangterminologyis anywhere in PowerBI and I'm not sure how I access it to build reports off of. Can someone tell me what my next step is after setting up the Gateway and adding a Data Source?
Thanks!
-Sarah
Solved! Go to Solution.
If you have connected to files on Dropbox successfully with Power BI Desktop or Service,
After downloading on-premise gateway and sign in with your Power BI account,
Under this dataset->setting->schedule refresh, select "annonymous" authetication under edit credential.
See more details how to set up schedule refresh from this article
Gateway connection->Data source credentials->configure Scheduled refresh
If you haven't connected to files on Dropbox successfully with Power BI Desktop or Service,
Please read through these articles and have a try:
Connecting to data source hosted on Dropbox
Excel sheet hoosted in Dropbox
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If you have connected to files on Dropbox successfully with Power BI Desktop or Service,
After downloading on-premise gateway and sign in with your Power BI account,
Under this dataset->setting->schedule refresh, select "annonymous" authetication under edit credential.
See more details how to set up schedule refresh from this article
Gateway connection->Data source credentials->configure Scheduled refresh
If you haven't connected to files on Dropbox successfully with Power BI Desktop or Service,
Please read through these articles and have a try:
Connecting to data source hosted on Dropbox
Excel sheet hoosted in Dropbox
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.