ssms
4 TopicsLocal SQL Server unable to retrieve data from Microsoft Fabric Lakehouse through SSMS
Hi everyone, I am able to successfully connect to a Microsoft Fabric Lakehouse from SSMS. I also have a local SQL Server instance running on localhost. However, the issue is that my local SQL Server connection is unable to retrieve/load data from the Fabric Lakehouse connection. Scenario: Fabric Lakehouse connection works in SSMS Localhost SQL Server connection also works separately But I cannot pull Fabric data into local SQL Server tables I would like to understand: Is direct data transfer between Fabric Lakehouse and local SQL Server supported through SSMS? Can stored procedures or queries in localhost SQL Server access Fabric Lakehouse tables? Are linked servers, external tables, gateways, or any additional configurations required? What is the recommended approach for loading Fabric data into local SQL Server tables? My objective is to validate large-volume data movement between the source and local target tables. Any guidance would be appreciated.Solved418Views1like4CommentsPower BI Desktop
Hi, I have installed Power BI desktop RS January 2023 and the SSMS 19.0.2 I get an error message "We're not able to upload this report. The report was created with a recent version of Power BI Desktop that is not yet supported by this server." I can see that some people had this issue in 2020 but I could not find a solution. Do I need to install an earlier version of Power BI desktop? or does anyone have a solution. Any help would be greatly appreciated. Thanks in advanceSolved2.2KViews0likes6CommentsConnecting to Reporting Server instance from SSMS
I have Power BI Reporting Server Jan 2021 installed. It is configured with Custom Security (as per this: https://github.com/microsoft/Reporting-Services/tree/master/CustomSecuritySample) PBIRS is working abosultely fine. I am able to access the portal and do all the reporting operations. However I am required to update some headers and trying to follow the steps from this link https://docs.microsoft.com/en-us/sql/reporting-services/tools/server-properties-advanced-page-reporting-services?view=sql-server-ver15. I am getting invalid user credentails, no matter what combination I try. Please help!2.3KViews0likes4CommentsReport server on premise - how to change size of max dataset in SSMS
Hi everybody, I have a problem with some datasets that need to be available in reporting server. Unfortunately we passed the limit of 1GB. From the change logs i can see that there is an option to change the dataset size from default 1GB to 2 GB but i cannot find in the config. Have someone did it and can pass me a screen where the option is ? Thanks in advance!3.3KViews0likes3Comments