exporting and importing sharepoint sites
Good morning everyone! I've set up a SharePoint site with various security groups, flows, forms, and PowerApps linked together to collaborate. What I'd like to achieve is the ability to export this setup and import it into another environment. I've noticed that through Power Admin, flows and PowerApps can be saved. However, SharePoint sites cannot be saved using this method. I've read online that this might be achievable with PowerShell using the Export-SPWeb command. However, I'm not entirely clear on the exact steps to follow. Does anyone have experience with exporting and importing SharePoint sites? Could you please provide a step-by-step guide on how to do this? If there's an alternative method other than the command mentioned above, I'd also appreciate hearing about it. Thank you in advance!
Server refresh gives Table not found error but fine in desktop
I'm trying to set up my scheduled refresh for my PowerBI report - the connection is an ODBC on import, I have the required drivers and get a green check when I test the connection, however when I refresh I get the following error: SessionID: b5ba2f83-45cb-4fab-8a0e-8a79b6cdbf0c [0] -1055784932: DataSource.Error: ODBC: ERROR [42S02] [Cache ODBC][State : S0002][Native Code 30] [D:\Program Files\Microsoft Power BI Report Server\PBIRS\ASEngine\MDataEngine\Mi] [SQLCODE: <-30>:<Table or view not found>] [Location: <Prepare>] [%msg: < Table 'DBO.DSKILLSETSTAT' not found>]. DataSourceKind = Odbc. DataSourcePath = dsn=MYDSNLOCATION. OdbcErrors = #table({"SQLState", "NativeError", "Message"}, {}). . The exception was raised by the IDbCommand interface. [1] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface. [2] -1055129594: The current operation was cancelled because another operation in the transaction failed. [3] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface. [4] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface. My refresh works just fine in PowerBI desktop, no issues with queries on any tables, it's clearly connecting to the source ok, I'm not sure what I'm missing. I can refresh and save the updated file in desktop and the report data refreshes on server. I'm not sure how or why it can't find the table any more. Here's a snip of the connection structure if I'm creating a new source - the table being queried is called dSkillsetStat in the dbo folder
Stored Procedure
Hi, I've been following the below link to get a SP into Power BI with parameters and managed to get so far but when invoking I'm getting this error message: I've looked at the query and can't for the life of me see where this error is. I'm sure it's very obvious so any help would be greatly appreciated. let SQLSource = (SiteId as number, Location as text, Retailer as text) => let Source = Sql.Database("NAV17-DR2", "PW-Reports", [Query="EXEC [planning].[Supply and Demand Extra Day - Report Data '" & Number.ToText(SiteId) & "', '" & (Location) & "','" & (Retailer) & "' #(lf)#(lf)#(lf)#(lf)#(lf)#(lf)"]) in Source in SQLSource https://www.c-sharpcorner.com/article/execute-sql-server-stored-procedure-with-user-parameter-in-power-bi/ Thanks in advanceUsing DAX in the Advanced Options area of Power BI Data import
Hi, Does anyone know where I can find some documentation, or examples, of DAX queries being used in the Advanced Options area of Power BI data import? I have an Azure Analysis Services data set that I want to pre-filter before I import it. The reason I'm not using Live Connection is because I want to try to reduce the data set and Live gives me the whole thing whether I'm using it or not, so I'm trying to retrieve the relevant tables only...I can do this but the data is still too large to import....hence the pre-filter. Any ideas? Thanks
PBI Report Server: import mode & data encryption
Hello, If I adopt import mode, the report is saved in Power BI Report Server. Is the report encrypted by default? Where is stored the report in the server? My report contains data affected by confidentiality information and I I have to guarantee encrypted data. Thanks for support, Marco.Automatic page refresh in power bi report server
i need to achieve 15 minutes page refresh such that it should refresh automatically and not by manually clicking on any button. The report needs to be viewed on a screen and no user will be interacting with it and it should refresh automatically. Am using import method in my data connection.
