Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I'm new to Power BI and I'm facing quite a few challenges.
1. I created a report on my PowerBI Desktop application connecting it to a file stored in my One Drive Business ( via navigating to the folder synced with my PC and not via URL). I did not think of my requirement then, but I need the report to be consumed by someone else who can update the One Drive Sheet that I will share with them. PBI Service won't allow me to refresh the data source, it's asking to get a gateway, which is a possible solution but not idle. Is there a way to fix my current source to One Drive Source?
2. Since it was not a big report, I decided that I will first create a data set in PBI Service using my One Drive file and then connect to this data set using PBI Desktop. The problem is, after connecting, PBI Desktop doesn't show the DATA or Table tab. So I'm not able to edit anything.
Secondly, I used a DAX:
Solved! Go to Solution.
Hi @Anonymous
In the second way, when connecting to Power BI dataset with Power BI Desktop, since this is a live connection, left-navigation and modeling are disabled, similar to the behavior when connected to SQL Server Analysis Services.
More explaination here:
In the first way, since you connect to on-premises folder,you need to add this data source under a gateway.
References how to install gateway and configure schedule refresh are as below:
https://docs.microsoft.com/en-us/power-bi/service-gateway-install
https://docs.microsoft.com/en-us/power-bi/service-gateway-manage
https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh
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.
Hi @Anonymous
Is this problem sloved?
If it is sloved, could you kindly accept it as a solution to close this case?
If not, please let me know.
Best Regards
Maggie
Hi @Anonymous
More quick and easy way:
How to Use and Refresh Power BI Using OneDrive Data Sources
This method contains two parts(more explanation in links below):
Connect to One Drive For Bussiness with Power BI Desktop using URL
Refresh a dataset created from a .CSV file on OneDrive or SharePoint Online
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.
Hi @Anonymous
In the second way, when connecting to Power BI dataset with Power BI Desktop, since this is a live connection, left-navigation and modeling are disabled, similar to the behavior when connected to SQL Server Analysis Services.
More explaination here:
In the first way, since you connect to on-premises folder,you need to add this data source under a gateway.
References how to install gateway and configure schedule refresh are as below:
https://docs.microsoft.com/en-us/power-bi/service-gateway-install
https://docs.microsoft.com/en-us/power-bi/service-gateway-manage
https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh
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.
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |