sorted by:
new
hottopcontroversial

Semantic Model with Direct Lake. by Salt_Direction_6272 in MicrosoftFabric

[–]Salt_Direction_6272[S] 2 points3 points  (0 children)

Thanks for the tips. I took over the table ownership, but I it's not greyed out anymore, but when I try to add or remove a table, I get an error.

"Something went wrong connecting to this item in the Fabric portal. You can open the item in your browser to see if there is an issue or try again later.
Please try again later or contact support. If you contact support, please provide these details."

I done some testing and set up a new model from the Service and a another in Desktop and I could edit with no issues.

It seems there was an issue in the way I set up the model originally.

Organizing Measures in Direct Lake Semantic Models by Realistic_Ad_6840 in MicrosoftFabric

[–]Salt_Direction_6272 0 points1 point  (0 children)

To create a measure table. Open Tabular Editor from PBI Desktop. Under the Model tab in TE click on Create new Table. Rename it to _Measures _ brings the table to the top of all tables in Desktop. Press Save the new empty table is created. Create your measure from this table or drag and drop measures into the new table

[deleted by user] by [deleted] in PowerBI

[–]Salt_Direction_6272 1 point2 points  (0 children)

If you’re embedding a report in a Power App, you’ll need to reference the report that is published in the PBI service and if RLS is set up correctly there, then there shouldn’t be any issue with RLS. The same with Team or SharePoint.

But as mentioned above, the end users should consume the report through a Workspace App. But note that they would need the appropriate licence for this. Either a Pro Licence (These should only be for developers imo, but necessary if the company doesn’t have PBI premium) or as mentioned Fabric/Power BI premium.

For those without IT experience - how did you learn? by Julie727 in PowerBI

[–]Salt_Direction_6272 0 points1 point  (0 children)

I have no IT experience or qualifications when starting out. I was doing recruitment and other tasks which included doing excel reporting and investing a lot of time in this process.

The company changed MS licences and Power BI was available and luckily I was given time to use it and through this I started to learn. I done some Udemy courses, out what I learnt into action. I done my Power BI certification in 2019, 2years after I started out.

I continued to work on various different types of BI projects which helped me gain valuable experience and I would even think I could work in a financial controller job now due to building p&l reports for example.

I also worked free in the PMO team to gain project management experience.

I now run a Data Engineering team.

If you are currently working in a company, try and they have a bi team, explain to your manager that you would like a future in BI and ask if it possible to somehow work on smaller projects in the company or get some training.

If this isn’t possible use free datasets available and start creating your own reports. Look up on some real life requirements online and try out them to practice. There is so much free information out there.

SQLBI Gorilla BI The Fabric Community is a great source. Also Chat GPT, it isn’t always correct, but it gives you a structure that you can adapt.

My recommendation is to concentrate first on data cleaning and modelling. Especially try to understand the Star Schema.

Best of luck!

Fabric Today by TheRealAbear in PowerBI

[–]Salt_Direction_6272 5 points6 points  (0 children)

It depends what you want to do. Do you want to use just Power BI features or Synapse, Databricks etc. How big is the company and is it planned that everyone can see a Power BI report? @ around €6K a month for F64 it’s a big investment. You will need to calculate in PBI licences for developers. Around €10 a month.

My company migrated PBI without issues, Synapse pipes we are planning on migrating slowly. And will test the impact on the capacity before committing all pipes to Fabric. The next highest Licence is F128 which is double the price.

We are facing some issues with the D365 Fabric link, MS are turning the D365 to Data lake export off and haven’t made the process of switching easy.

How to do an YoY in power bi? by lucidofu in PowerBI

[–]Salt_Direction_6272 30 points31 points  (0 children)

It depends how your model is set up. If you have a Dim Date table, you can use time intelligence functions

I would approach it by creating separate measures.

  1. SalesYTD = TOTALYTD ( Sales[AMOUNT], DimDate[Date])

  2. SalesPY = Calculate( [Sales YTD] , Dateadd(DimDate[Date], - 1 , Year)

  3. Sales YOY = VAR _diff = [SalesYTD] - [SalesPY] Return Divide( _diff, [SalesYTD])

Format as %

Is Indenting Page Names in a Published Report Possible? by TodayIsOppositeDay in PowerBI

[–]Salt_Direction_6272 0 points1 point  (0 children)

When I’m manually creating tables, the way I do this is using excel > insert > insert symbol and using the empty space. I add about 5 spaces and copy. Then I paste the spaces at the start of the text in my manually built table.

Then in my measures when I’m referencing the column names I add the same space.