A Power BI Report with multiple charts or other objects can be added to a Dashboard in Power BI Online using the pin to dashboard feature. However this results in a dashboard with very wide margins. This is especially problematic on a mobile device as the screenshot from the Power BI Android application shows. There is […]
How to avoid wide margins on a Power BI dashboard Read More »
This was a weird quirk. I have Power BI Free account and uploaded a report to Power BI Service. The report has dataset that gets data from a Sharepoint file. In Power BI Service I went to the dataset “Schedule Refresh”, selected “Connect Directly”, “Enter Credentials” as oAuth, then entered my Office 365 credentials. This
Careful! Don’t click “Try Power BI for free” Read More »
Do you want to create a Power BI Report that gets a daily scheduled refresh of data from a Sharepoint csv file? The first step is to create your Power BI report in Power BI Desktop using the Sharepoint csv file as data source. In Power BI Desktop use Get Data – File – Sharepoint Folder
How to schedule Power BI dataset refresh Read More »
I want to create a Power BI Online report with a data source from a file on a remote web server that updates automatically so my Power BI report is always up to date. Power BI Desktop and Online have lots of data connectors to third party ‘Online Services’ eg Salesforce, Mailchimp, Github, etc, as well as file and
Power BI Online – get data from Office 365 Sharepoint file Read More »
Microsoft has three file storage options: OneDrive Personal OneDrive Business Sharepoint These have recently been unified into one new OneDrive API https://dev.onedrive.com and oAuth is preferred method of authentication. However there are some key differences how the API: OneDrive Personal authenticates against oAuth account created at Microsoft Application Registration Portal using a Microsoft account (Live, Microsoft.com). Authentication url is: https://login.live.com/oauth20_authorize.srf OneDrive Business
OneDrive API features Read More »
