Gateway error - New to gateway concept
I have a Planning PowerBI dashboard created using desktop version and published to the planning workspace. I have created another dashboard called "Sales" by connecting to the semantic model of the planning database and published to the Sales workspace. While publishing, I get the following messages. "This semantic model contains calculated tables or calculated columns that refer to remote tables, which will result in refresh failure after publication if the dataset is not configured to use an explicit connection with granular access control to access this data source. Are you sure you want to continue publishing?" I say yes and publish to the Sales workspace. The publish confirmation is as below "Your file was published, but disconnected. Sales Dashboard is not connected to one or more data sources. To connect, go to dataset settings or ask the dataset owner." As I am the dataset owner, give me step by step guide to fix this as this is the first instance I am getting this type of error I am completely new to this gateway concept. I browsed a lot and still unable to fix it. Should somebody help, it would be great.
It is extremely necessary to finalize the Report Server with new functionality
Hello everyone It is extremely necessary to finalize the ReportServer with new functionality. We use the Power BI report server in our work and there are very few functions that all users need. The developers of Power BI RS kindly ask you to add them to the releases if possible: 1) subscription functionality (currently works only for reports built in Report Builder - we don't use it. It is extremely necessary to do for .pbix reports. This function is very necessary - as it is constantly required to export the report to PDF and print. Now there is no such functionality at all) 2) make a full-screen report rotation button - now half of the screen is occupied by panels at the top and pages at the bottom, as a result, 50% of the screen remains on the report itself at best. Yes, you can add rs:embedded to the link, but isn't it easier to make a full screen button??? 3) many-to-many connections - when will you make them? have you been feeding everyone with breakfast since 2020? 4) Call the RS system something else, we are tired of explaining to users that there is a Desktop RS and there is a Desktop and these are different software products. No one understands this. For Power BI users, this is one product, that RS, that Desktop, that service. Not only are they called the same - so they have the same icons and everything looks the same. Why not separate the RS tool and name it differently? to avoid confusion? 5) according to updates 3 times a year, this is very common. In recent updates, we have generally come to the fact that the color and several formulas are changing - and that's all there is in the update.. Sadly. I am in favor of having one annual update, but it included as many features as possible. This update will reveal and it will be easier for system administrators to update programs from users. Questions to Power BI developers - are there plans to do something on these points and if so, when to wait for solutions to the accumulated issues???
Scheduled Refresh
Hi everyone! I have this issue: [0] -1055784934: DataSource.Error: ODBC: ERROR [08S01] SQLColAttributeW unable due to the connection lost. DataSourceKind = Odbc. DataSourcePath = dsn=AIS_Observatory. OdbcErrors = error "Microsoft.Mashup.Engine1.Runtime.ValueException: [Expression.Error] Value was not specified.#(cr)#(lf) at Microsoft.Mashup.Engine1.Language.ValueCreator.CreateValueForNotImplemented(INotImplementedExpression expression)#(cr)#(lf) at Microsoft.Mashup.Engine1.Runtime.ListValue.DemandArrayListValue.get_Item(Int32 index)#(cr)#(lf) at Microsoft.Mashup.Engine1.Runtime.BufferedListValue.BufferedValueReference.get_Value()#(cr)#(lf) at Microsoft.Mashup.Engine1.Runtime.TableTypeValue.FromValue(ListValue columns, TypeValue defaultColumnType)#(cr)#(lf) at Microsoft.Mashup.Engine1.Runtime.TableTypeValue.FromValue(Value columns, TypeValue defaultColumnType)#(cr)#(lf) at Microsoft.Mashup.Engine1.Library.Table.TableModule.Table.FromRowsFunctionValue.TypedInvoke(ListValue rows, Value columns)#(cr)#(lf) at Microsoft.Mashup.Engine1.Runtime.NativeFunctionValue2`3.Invoke(Value arg0, Value arg1)#(cr)#(lf) at Microsoft.Mashup.Engine1.Language.ValueCreator.<>c__DisplayClass23_0.<CreateValueForRecord>b__0(Int32 index)#(cr)#(lf) at Microsoft.Mashup.Engine1.Runtime.RecordValue.DemandRecordValue.get_Item(Int32 index)#(cr)#(lf) at Microsoft.Data.Mashup.ProviderCommon.MashupResource.TryGetValue(Func`1 getValue, IValue& value, String& errorMessage)#(cr)#(lf)Record". . The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. The scheduled refresh was working fine and suddenly stop working. Please, I need some help!!!!!!!!!!
problema descargando .pbix
Buen dia comunidad, estoy intentando descargar el .pbix de un workspace pero me sale el siguente error. Identificador de actividadf1abf07a-1ebd-45ea-8170-be81f55a1277 Identificador de la solicituda48a9785-8044-9d45-9ef3-f9de020652c8 Id. de correlaciónafded00f-be72-e62a-4f67-db1fa1f9458b Código de estado0 HoraMon Mar 27 2023 15:59:03 GMT-0500 (hora estándar de Colombia) Versión del servicio13.0.20342.55 Versión del cliente2303.3.12949-train alguien sabe de que manera puedo descargar este archivo?
SAP Business Warehouse Message Server data source not supported on Power BI report server?
Hello everyone, I am facing an issue with connecting to an SAP Business Warehouse Message Server data source on Power BI report server, and I would appreciate some advice from the community on how to resolve it. When I try to connect to the SAP Business Warehouse Message Server data source on Power BI report server, I receive an error message stating that the data source is not supported. However, I am able to connect to the same data source without any issues using the Power BI desktop application. I have tried several troubleshooting steps, including ensuring that the necessary drivers are installed on the report server, but none of these steps have resolved the issue. I suspect that this could be a compatibility issue between SAP Business Warehouse Message Server and Power BI report server. However, I am not sure how to confirm this or what steps I can take to resolve it. Has anyone in the community encountered a similar issue, and if so, what steps did you take to resolve it? I would appreciate any advice or suggestions on how to resolve this issue. Thank you in advance for your help.
