Forum Discussion
Basic questions Power BI
Hello everyone 😉
COuld you please help to understand the below:
1. Am I right the visualisations are quite limited in Powe BI? So meaning a simple table I cannot adjust as I want? Only have few options that Power BI is giving me?
2. If I need to update a database every week on existing data base, but I had changed a clomun in the first database from "whole number" to "decimal number" - is there any way not to change it each time for the next added on top databases?
3. Also is there a way for all numbers to have them by default as decimal?
I'll try to answer your questions:
- You can import table as big and complex as you wish in Power Bi and then manipulate the table in many different ways before selecting the right visual for the data you want to display. A more precise example of what you'd like to achieve might be useful here.
- As long as the column names remain the same from one udpate to the next one, the refresh of Power Bi will go without any issue. If columns are renamed or deleted, then Power Bi will show an error in the refresh and you will need to go in and correct the issue in the "Transform Data" tab.
- If the initial database (for example an excel file) has the data already formatted as decimals, they will be read as decimals in Power Bi too. If the data is not formatted, Power Bi will automatically format it to what it thinks is best. But you might need to change the format when you first import the data to make sure it is the way you want it. Afterwards, the format will not change without your input.
Hope that answers your questions.
HEllo Anonymous ,
1- yes, but also there are custom visuals that you can use.
check them out https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals
check them in power bi https://youtu.be/tDfKcPoiOwU?si=-5E4VW-1dfHOeKpS
2- power query in power bi will detect the custom type as you load it, so if it was change then it will change.
3- no, it will detect it as number if there's no decimal, but you can change it in power query to a decimal so it will ente everytime as decimal.
2 Replies
HEllo Anonymous ,
1- yes, but also there are custom visuals that you can use.
check them out https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals
check them in power bi https://youtu.be/tDfKcPoiOwU?si=-5E4VW-1dfHOeKpS
2- power query in power bi will detect the custom type as you load it, so if it was change then it will change.
3- no, it will detect it as number if there's no decimal, but you can change it in power query to a decimal so it will ente everytime as decimal.
I'll try to answer your questions:
- You can import table as big and complex as you wish in Power Bi and then manipulate the table in many different ways before selecting the right visual for the data you want to display. A more precise example of what you'd like to achieve might be useful here.
- As long as the column names remain the same from one udpate to the next one, the refresh of Power Bi will go without any issue. If columns are renamed or deleted, then Power Bi will show an error in the refresh and you will need to go in and correct the issue in the "Transform Data" tab.
- If the initial database (for example an excel file) has the data already formatted as decimals, they will be read as decimals in Power Bi too. If the data is not formatted, Power Bi will automatically format it to what it thinks is best. But you might need to change the format when you first import the data to make sure it is the way you want it. Afterwards, the format will not change without your input.
Hope that answers your questions.