Power BI Report Server - Data Sources to Use and Connect
Hi d_gosbell , Currently I'm working with Power BI Reports on PBI Desktop for Report Server. Have the PBIRS (Jan 22) Version via SQL Enterprise. Edition. Most of my company's data is stored in Excel Shared Spreadsheets on Sharepoint Online, or the Excel File is locally maintained and sent via emails to the team. Data Sources Currently - Shared Excel Doc on Sharepoint Online, Excel Doc - received by email weekly or so, and an Excel Sheet (Connected to SQL directly) - but I need to actually click on the refresh button to refesh the data in the sheet. 1) Shared Excel Spreadsheet on Sharepoint Online - As PBIRS does not support refresh for sharepoint online data sources. What is the alternative here? Saving the Excel Sheet on the test server (where the PBIRS system is) - leading to question 2 below. 2) Excel Doc via Email weekly - An Excel File saved locally on my own System. If there are any updates - I would want it to reflect in the PBI Report too. Now, since I cannot refresh a locally connected file on my system in the report in the web portal. When I asked this previously, you mentioned that you need to change the data source in Power BI Desktop to point to a network share using a UNC path. These usually look something like the following \\server\sharename\folder\file.xlsx Can you elaborate what this means? Does this mean that I should save this Excel file on the Test Server (Where PBIRS is present) so that the Data source also refreshes in the web portal? 3) Refreshable Excel Sheet - If this Excel Sheet - Connected to PBI Directly. I would still have to click the refresh button myself in the Excel Sheet - and then those updates - will come up in PBI when refreshed. There is no way to automatically refresh and update the data in PBI right. So, as Excel is directly connected to the Company's SQL Server, I would have to do the same with PBI and directly connect it to SQL. So, in PBIRS Web Portal, I click on Manage - Data Source - Give the creds for SQL then? Is that correct? How is PBIRS connected to SQL? You had mentioned I can take the Query from Advanced Editor (in the Refreshable Excel Sheet - Query Editor) then paste the same in a blank query in PBI to directly connect it to SQL right. The issue is that, the Query Editor in Excel is blocked, I don't seem to have access to view the query. So, I have to request my Company's IT to connect the PBI too SQL then right? 4) Last Q, there is a lot of data saved on internal Company systems (on SQL or Oracle Databases) - for that connection to PBI, I will have to request IT from my company to assist on that right. Thanks in advance! Really appreciate all your support.
Data Source Connection Properties, Azure SQL question
I have a paginated report that gets data from an Azure SQL Server. In the SQL code in the Dataset, one column is CURRENT_USER that gets me the AD user email address when running the SQL code outside the report. When uploading the report to a Power BI Workspace the CURRENT_USER column is empty. How do I configure the data source in Power BI report builder without adding user/PW in the data source and use 'ActiveDirectoryIntegrated'. Tried a lot of settings but don't get it to work. Either I have to add a user in the data source or it dont work in the report. Used 'ActiveDirectoryIntegrated' in Advanced properties. Thanks.Hosting PBI Desktop reports on Report Server
I just have some basic questions about this. If I publish a Power BI Desktop report to Report Server on premise, do I need a gateway for Azure Cloud data sources whether it is import or direct query or live connection? But a report using on premise data sources will be accessible if published to Report Server whether it is import or direct query or live connection, right? Also, I have run into an issue where I have tried to upload a Desktop report to Report Server and I got the following message: "We can't save this Power BI Desktop report because either it is newer version or has component parts that are not supported." The version of Desktop I am using is the one which I downloaded using the link from the Report Server page, so it is the same version. I tried to test uploading a very basic report with just a table, using imported data from a SQL Server database. Any idea what the component part which is not supported could be?
Download & Modify a report from Power BI server which you don't have access to its data source
Hello Everyone, Kindly I need your help to answer the below questions regarding PBIRS I have the following scenario: Usar A has access from his personal PC to "x data source", and he created a report by using the data from this "x data source". Then he uploaded this report to the PBIRS. Please notice that the PBIRS also has an access connection to the "x data source", and User B only has access to the PBIRS but not the "x data source". If User B downloaded the report (which was created by User A) on his personal PC, can he has access to the "x data source" and refresh the report only because he has access to PBIRS? Will User B be able to modify the report on his personal PC even if he doesn't have access to the data source of the report? if yes, then if he uploaded the report to the server again, will we be able to make the "pre-set refresh job" to refresh the report again? Thank you so much in advance 😀
