Hello bas I have a date slicer and bar chart. Now if I select the custom range for example (april 7 - april 29) it should show as days in x axis if we select 1 month of custom date (may 15- June 15) then it should show as months. Like wise for years. Is this possible?
Thank You BAS: Is there a way to connect a excel data from Desktop to PowerBI online? I have an excel report which will be updated on every week, what i am doing now is updating the data in the excel open PowerBI desktop refresh my report and then publish the report to the workspace. Rather i want to connect the Excel report directly into my PowerBI online. Please provide some tips
Hi Can anyone help with the error message (" [Expression, Error] The key didn't match any rows in the table") I am getting while running the power query? Basically, I have a Power Query appending 19 Excel files from a folder but sometimes when I am refreshing the data the files may be in use by users and this error message will pop up.
Hi @How to Power BI - do you know any solution to fix refresh errors linked to blank files? My data set is located in a SharePoint which contains multiple JSON files. Every once and then a blank JSON file is created. When I try to refresh my dashboard an end of buffer memory error occurs. For now, the solution that I found is to manually delete the affected files in the server - but this is not very convenient. I am wondering in there is any way to instruct Pbi to skip blank files?
Sir please ask subscribers for their problem and scenarios which they are facing when developing reports... So most of them will tell you about their problems and scenarios so you can make videos on solving that problem... So more the content, more the comments and more the views as well subscribers.... Because you have much expertise in DAX... Thanks I mean to start doubt clearing video series... And put it the pbix file along with that video... So it will also useful
For excel files this is seems perfect. What if we had errors with tables from import or direct query from a data base?
Wonderful. Thank you so much. And greatly explained as usual.
this is absolutly amazing !! thank you for sharing
WoW! Thank you so much, extremely helpful! Amazing solution and clear explanation! Thanks again!
Hi Jola! Thank you for the kind words much appreciated and super happy to hear its helpful :)
Hello bas
I have a date slicer and bar chart.
Now if I select the custom range for example (april 7 - april 29) it should show as days in x axis if we select 1 month of custom date (may 15- June 15) then it should show as months. Like wise for years.
Is this possible?
Thank You
BAS: Is there a way to connect a excel data from Desktop to PowerBI online?
I have an excel report which will be updated on every week, what i am doing now is updating the data in the excel open PowerBI desktop refresh my report and then publish the report to the workspace.
Rather i want to connect the Excel report directly into my PowerBI online. Please provide some tips
Put the Excel file in One Drive.
as TainuiaKid1973 suggests or create a data set in power bi service (for now copy paste, excel will be added soon)
I am having issue for the refresh. I just update the data and it doesnt updating the new data in the power bi .
Hi Can anyone help with the error message (" [Expression, Error] The key didn't match any rows in the table") I am getting while running the power query? Basically, I have a Power Query appending 19 Excel files from a folder but sometimes when I am refreshing the data the files may be in use by users and this error message will pop up.
Thanks for sharing great content!! 👏
Awesome Bas!! Thank you for amazing video
May be a video on how create your videos
Really unique ..
Hi @How to Power BI - do you know any solution to fix refresh errors linked to blank files?
My data set is located in a SharePoint which contains multiple JSON files. Every once and then a blank JSON file is created. When I try to refresh my dashboard an end of buffer memory error occurs.
For now, the solution that I found is to manually delete the affected files in the server - but this is not very convenient. I am wondering in there is any way to instruct Pbi to skip blank files?
How to know where the error is, when we have so many columns and rows? Is there a way to find the errors without navigating the query?
Can we include the wrong data type? how do we do that?
Thank you. Further, the email should have a (paginated) report containing the error details sent to respective file owners.
Thanks for the amazing video!!! The download link is not working
thank you!! I've added the link 🙂
@@HowtoPowerBI Thank you so much Bas!!! 😊
Very, very nice.
Thx Drew! 🙏
Thank you
thx for watching!!! 😀
Sir please ask subscribers for their problem and scenarios which they are facing when developing reports...
So most of them will tell you about their problems and scenarios so you can make videos on solving that problem...
So more the content, more the comments and more the views as well subscribers....
Because you have much expertise in DAX...
Thanks
I mean to start doubt clearing video series...
And put it the pbix file along with that video... So it will also useful
I want to create dashboard which will show success and failure status of powerbi Dataset without going to Dataset
then I hope this video will help you 🙂
Amazing… but 😵💫
I have no idea what he is saying
Oh how come?
Amazing content! Thanks for sharing!!