website
6 TopicsGet xlsx file from website
Hi guys, I am trying to find solution how can i link external data source to PBI . In my case my data is .xlsx file located on web page, and i have several of them. So basically i need get excel files from web pulled in to PBI and have it automated, because this files refresh each day. i have this (did use custom name to protect source web page - name.something.com/admin file1_2023-01.xlsx file1_2023-02.xlsx file1_2023-03.xlsx file1_2023-04.xlsx file1_2023-05.xlsx7.6KViews0likes5CommentsError
I am trying to access this website ConsultsByOrderDate - Power BI Report Server (va.gov) I am getting the error An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection) The target principal name is incorrect. Cannot generate SSPI context.Solved1.3KViews0likes2CommentsHow to work with REST API
Hi, I've been using Power BI for a while, but I have encountered a problem recently when trying to connect to the GtR website. https://gtr.ukri.org/ This is a portal with all projects funded by UK Research Councils. At the bottom it says we can use REST APIs. I don't how to work with the 2 APIs they indicate at the bottom of their website: I've use the website address and the links provided in the APIs pdfs (https://gtr.ukri.org/resources/api.html) and paste them in "Get Data > website". But, the info I get is weird and is not comparable to all the information provided in the website. So, I'm doing something wrong here... Any help? Thanks.Solved2.9KViews0likes3CommentsStoring data and visualization in a cloud and access them without a VPN Connection
Hello, is it possible to make my data, which are stored in a cloud (with a win server), accessible to the outside thgrough the report server? I would like to access my dashboard without a VPN Connection and just to type the website address via a webbrowser and see my dashboard. Is this possible? In case it works, is it just possible to see the dashboard with a user licence? Do I need for this Idea Power BI Premium? (to embed the dashboard) best regards842Views0likes0CommentsAccessing Dashboards via en external Cloud (without VPN)
Hello, I have some questions about embedding dashboards on websites that only certain customers are allowed to access (for example: by login). Currently I have a cloud. The Cloud has a database and a Windows server. Right now, potential customers are able to access a dashboard via a VPN connection. However, they would first have to login via the VPN, which I would like to avoid. I thought about getting a Domain or open my Cloud to the outside, so there would be no VPN connection needed in future. Now Im not sure which product is right for that case? Would Power BI Premium with Report Server be the right solution or Power BI Embedded? Thanks and best regards, nika1.3KViews0likes1Comment